1 Debris Model Analysis

This report is split into multiple sections, which you can access with the tabs below. There is a summary, then Vegetative Debris and Construction Debris, and an Appendix. You can switch between the tabs/analysis by clicking the tab headers below: ______________________________________________________________________

1.1 BLUF

We support the following formulas for Vegetative debris prediction and Construction debris predictions:

1.1.1 Vegetative

\[Cost = 10^{(log10( Cubic Yards )*0.73076 + 2.5827 )}\]

1.1.2 Construction

\[Cost = 10^( log10 (Cubic Yards )*0.54892 + 3.5681)\] The analysis and explanation for each of these follows below. The multipliers(cost per cubic yard) and the intercept (base costs for removal) are derived from linear regression.

Use the table of contents to the left, and the analysis tabs to view a given section.

1.1.3 Debris Data

Below is data aggregated to separate instances of debris removal at the county level. We briefly view the data below, and will use Gross_Cost and Quantity (in Cubic Yards) to calculate ratios and relationships like ‘cost per cubic yard’ across the counties and projects in the dataset. We are including all regions in this version of the analysis, to be able to fit more robust relationships between cost and quantity.

  • Data Range: 2016-2024
  • Regions: (ALL)
  • Number of Debris Removals: 14384
Disaster_Number Incident_Type Declaration_Date Region_Number State Applicant_Damage_CatA_Removal_Id Applicant_Damage_Id Applicant_Project_Id Applicant_Id Applicant_Name Event_Id County FIPS Gross_Cost Net_Cost Work_Category Location_Type Debris_Type Debris_Type_Other Quantity Quantity_Unit_Of_Measure Start_Date End_Date
4673 Hurricane 2022-09-29 4 Florida 42697 1305611 708608 201362 Florida Division of Emergency Management 1732 Leon County 12073 4208286.2 4208286.2 A Public ROW Vegetative Debris NA 48.6128 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 41281 1256239 687485 201362 Florida Division of Emergency Management 1732 Leon County 12073 65804428.0 65804428.0 A Other Public Property Vegetative Debris NA 100000.0000 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42599 1305614 708612 201362 Florida Division of Emergency Management 1732 Leon County 12073 2082260.3 2082260.3 A Public ROW Vegetative Debris NA 3266.6500 Cubic Yard 2022-12-08 2023-01-24
4673 Hurricane 2022-09-29 4 Florida 42607 1305614 708612 201362 Florida Division of Emergency Management 1732 Leon County 12073 2082260.3 2082260.3 A Public ROW Vegetative Debris NA 5999.5400 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42422 1265535 692446 201362 Florida Division of Emergency Management 1732 Leon County 12073 41109052.2 41109052.2 A Waterway Vegetative Debris NA 87744.5500 Cubic Yard 2022-12-08 2023-01-24
4673 Hurricane 2022-09-29 4 Florida 41403 1259472 689433 201362 Florida Division of Emergency Management 1732 Leon County 12073 41768603.2 41768603.2 A Public ROW Vegetative Debris NA 1500000.0000 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42431 1265535 692446 201362 Florida Division of Emergency Management 1732 Leon County 12073 41109052.2 41109052.2 A Waterway Vegetative Debris NA 140391.2800 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42452 1304851 708168 201362 Florida Division of Emergency Management 1732 Leon County 12073 8306922.7 8306922.7 A Public ROW Vegetative Debris NA 7790.0000 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42445 1304851 708168 201362 Florida Division of Emergency Management 1732 Leon County 12073 8306922.7 8306922.7 A Public ROW Vegetative Debris NA 3819.0000 Cubic Yard 2022-12-08 2023-02-09
4673 Hurricane 2022-09-29 4 Florida 42405 1305219 708411 201362 Florida Division of Emergency Management 1732 Leon County 12073 15657618.7 15657618.7 A Public ROW Vegetative Debris NA 352620.0000 Cubic Yard 2022-12-08 2023-02-15
4673 Hurricane 2022-09-29 4 Florida 42345 1305219 708411 201362 Florida Division of Emergency Management 1732 Leon County 12073 15657618.7 15657618.7 A Public ROW Vegetative Debris NA 286696.9400 Cubic Yard NA NA
4673 Hurricane 2022-09-29 4 Florida 42686 1305611 708608 201362 Florida Division of Emergency Management 1732 Leon County 12073 4208286.2 4208286.2 A Public ROW Vegetative Debris NA 28336.7000 Cubic Yard 2022-12-08 2023-01-24
4578 Severe Storm(s) 2021-01-12 8 Utah 34246 439802 172555 53511 Utah (Utah Division of Emergency Management) 491 Salt Lake County 49035 422306.6 422306.6 A Public ROW Vegetative Debris NA 9554.0000 Cubic Yard 2020-09-08 2020-10-26
4655 Severe Storm(s) 2022-06-16 8 Montana 41490 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 30363.1000 Cubic Yard 2023-07-15 2023-09-30
4655 Severe Storm(s) 2022-06-16 8 Montana 41501 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 2755.2000 Cubic Yard 2023-04-10 2023-06-30
4655 Severe Storm(s) 2022-06-16 8 Montana 41481 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 5023.2000 Cubic Yard 2023-05-19 2023-06-23
4655 Severe Storm(s) 2022-06-16 8 Montana 41503 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 3651.0000 Cubic Yard 2023-04-25 2023-05-01
4655 Severe Storm(s) 2022-06-16 8 Montana 41476 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 2062.9000 Cubic Yard 2023-05-01 2023-06-22
4655 Severe Storm(s) 2022-06-16 8 Montana 41504 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 9049.8000 Cubic Yard 2023-05-08 2023-06-19
4655 Severe Storm(s) 2022-06-16 8 Montana 41505 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 2601.9000 Cubic Yard 2023-05-04 2023-05-07
4655 Severe Storm(s) 2022-06-16 8 Montana 41508 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 910.9000 Cubic Yard 2023-04-26 2023-06-27
4655 Severe Storm(s) 2022-06-16 8 Montana 41511 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 2090.2000 Cubic Yard 2023-05-31 2023-06-22
4655 Severe Storm(s) 2022-06-16 8 Montana 42002 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 6331.3000 Cubic Yard 2023-05-07 2023-06-30
4655 Severe Storm(s) 2022-06-16 8 Montana 41470 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 54753.8000 Cubic Yard 2023-06-06 2023-07-12
4655 Severe Storm(s) 2022-06-16 8 Montana 41473 1238782 679681 199625 Montana Disaster & Emergency Services 1709 Lewis and Clark County 30049 4623743.1 4623743.1 A Waterway Vegetative Debris NA 1121.1000 Cubic Yard 2023-07-10 2023-07-10
4663 Flood 2022-07-29 4 Kentucky 44887 1248085 688836 200220 KY Division of Emergency Management 1718 Franklin County 21073 25248115.2 25248115.2 A Public ROW Vegetative Debris NA 8072.9400 Cubic Yard 2022-08-04 2023-02-01
4663 Flood 2022-07-29 4 Kentucky 44664 1248084 688835 200220 KY Division of Emergency Management 1718 Franklin County 21073 20835364.4 20835364.4 A Public Road Vegetative Debris NA 1305964.0000 Cubic Yard 2022-08-08 2022-09-06
4663 Flood 2022-07-29 4 Kentucky 44405 1248091 688844 200220 KY Division of Emergency Management 1718 Franklin County 21073 11305017.6 11305017.6 A Waterway Vegetative Debris NA 315639.3600 Cubic Yard 2022-08-08 2022-09-06
4476 Tornado 2020-03-05 4 Tennessee 33378 377703 136382 21710 Tennessee Department of Military/TEMA 265 Davidson County 47037 614317.3 614317.3 A Public Road Vegetative Debris 3131.0000 Cubic Yard 2020-03-03 2020-03-29
4557 Severe Storm(s) 2020-08-17 7 Iowa 32324 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 4000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32323 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 9000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32325 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 7000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32322 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 2800.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32321 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 7000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32326 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 22600.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32320 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 1100.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32327 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 20400.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32318 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 3000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32317 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 8000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32316 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 9500.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32315 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 3000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32314 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 20000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32328 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 1000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32313 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 17000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32330 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 3500.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32312 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 25000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 33386 418197 161938 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 5056100.1 5056100.1 A Other Public Property Vegetative Debris NA 1346068.0000 Cubic Yard 2020-09-21 2020-12-21
4557 Severe Storm(s) 2020-08-17 7 Iowa 33003 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 500.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32329 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 9000.0000 Cubic Yard NA NA
4557 Severe Storm(s) 2020-08-17 7 Iowa 32311 405187 155915 48341 Iowa Department of Homeland Security and Emergency Management 451 Polk County 19153 3443899.9 3443899.9 A Other Public Property Vegetative Debris NA 1500.0000 Cubic Yard NA NA

1.2 Veg-Debris

1.2.1 The Vegetative Debris Data

Disaster_num FIPS Dec_Date Num_Removals Num_Damages Num_Projects Gross_Cost Net_Cost Quantity year Population Infrastructure_Value RISK_SCORE RESL_SCORE disasterName incidentType region
4284 13021 2016-10-09 1 1 1 59753.43 59753.43 0.00 2016 157280 31029231200 76.42380 65.85 HURRICANE MATTHEW Hurricane 4
4284 13025 2016-10-09 4 4 4 242878.98 242878.98 59825.00 2016 17976 2506510997 57.46102 24.76 HURRICANE MATTHEW Hurricane 4
4284 13029 2016-10-09 370 10 9 1232186.75 1232186.75 156564.45 2016 44426 6670531454 87.52784 78.64 HURRICANE MATTHEW Hurricane 4
4284 13031 2016-10-09 12 9 9 2055807.22 1716018.52 176455.11 2016 80942 14170658859 89.21413 47.96 HURRICANE MATTHEW Hurricane 4
4284 13039 2016-10-09 10 10 8 525855.78 525855.78 6462364.82 2016 54619 8633305371 85.30067 57.57 HURRICANE MATTHEW Hurricane 4
4284 13043 2016-10-09 5 5 5 137094.82 137094.82 2038.40 2016 10953 1814850368 40.18454 5.54 HURRICANE MATTHEW Hurricane 4
4284 13051 2016-10-09 59 48 29 94891483.38 48112145.72 1941658.36 2016 293520 56341879834 98.66370 90.77 HURRICANE MATTHEW Hurricane 4
4284 13103 2016-10-09 13 13 10 483461.32 483461.32 18393.00 2016 64648 9810531158 79.16004 62.13 HURRICANE MATTHEW Hurricane 4
4284 13109 2016-10-09 6 6 6 311933.31 311933.31 49181.00 2016 10729 2224696592 63.85619 29.09 HURRICANE MATTHEW Hurricane 4
4284 13121 2016-10-09 5 5 5 5540903.00 5540903.00 210105.62 2016 1065539 231755056791 92.30035 55.28 HURRICANE MATTHEW Hurricane 4
4284 13127 2016-10-09 30 12 12 17031721.60 11648106.88 675247.55 2016 84424 16154990642 90.80496 83.99 HURRICANE MATTHEW Hurricane 4
4284 13165 2016-10-09 2 2 2 21963.86 21963.86 207.44 2016 8650 1504153897 28.57143 11.04 HURRICANE MATTHEW Hurricane 4
4284 13179 2016-10-09 8 8 8 2412210.84 2412210.84 315013.07 2016 65134 12052551996 94.11390 50.48 HURRICANE MATTHEW Hurricane 4
4284 13183 2016-10-09 4 4 4 212102.25 212102.25 7388.50 2016 16069 1885031282 56.47471 6.91 HURRICANE MATTHEW Hurricane 4
4284 13191 2016-10-09 4 4 4 1789692.63 1789692.63 80688.62 2016 10934 2539384376 79.28731 45.93 HURRICANE MATTHEW Hurricane 4
4284 13229 2016-10-09 5 5 5 134919.75 134919.75 7012.72 2016 19713 3511888999 70.15590 39.24 HURRICANE MATTHEW Hurricane 4
4284 13247 2016-10-09 101 2 2 19160893.85 1980813.65 173142.70 2016 93392 17184906899 63.88801 44.08 HURRICANE MATTHEW Hurricane 4
4284 13251 2016-10-09 4 4 4 204294.87 204294.87 101575.00 2016 13974 2746722077 67.99236 29.54 HURRICANE MATTHEW Hurricane 4
4284 13267 2016-10-09 11 5 5 1660602.41 916350.53 140426.00 2016 22744 4622910204 83.32803 11.81 HURRICANE MATTHEW Hurricane 4
4284 13277 2016-10-09 1 1 1 0.00 0.00 6479.00 2016 41296 10042961707 73.84664 42.58 HURRICANE MATTHEW Hurricane 4

1.2.2 Distribution of Costs per Cubic Yard

##     Min.  1st Qu.   Median     Mean  3rd Qu.     Max. 
##     3.58    19.70    27.09   236.10    43.93 80868.80

Minimum, Central Tendency and Quartile Points. Median Cost is at $27.09 dollars. The Mean is skewed by extremely high cost projects. This is also why we log (exponentially) scale quantity and cost in most of the analysis.

Histogram showing the frequency of projects around certain cost per cubic yards. Region 4 looks very similar to the others.

1.2.2.1 Chart of Cost against Quantity

Notes: - This is on log-log scales, so major tick lines increase by powers of 10: - This allows us to again confirm that Region 4 is similar to other regions. - We can start to see an approximately linear relationship between cost and quantity. - There are some outliers we need to remove: - Low values for Cost/Quantity (probably incorrect info, or not entered info)

1.2.2.2 Chart with Regression and Line Relationships

Quite the chart! First, R4 is not separated out (it would be too confusing and we don’t need to anyway). - What I find interesting here, is the evidence for a changing relationship between Cost and Quantity. - If we use a multiplier like \(25 (1 CY of debris cost 25)\) we would have a single straight line, but it wouldn’t fit well at the beginning or end of the chart.

  • The line that fits on this chart (green line) is actually a log-log line assuming an equal scaling relationship (slope =1) between the variables. This is actually a scaling relationship that looks straight because we transformed Cost and Quantity with a log10 function. -I adjusted the intercept (“base cost”) of where the line starts to make it fit close to the scattered data cloud.
  • Note: the Orange line will be used to filter out the extremely large debris removal amounts.

One more chart: - The blue line is a regression relationship. - The long green line is one that I fit “by eye”.

1.2.3 Fitting a Regression Line

  • The previous lines were fit “by eye”.
  • We can use regression to find slope and intercept for the relationship.
veg_model <- 
veg_pred %>% 
  filter(Quantity > 10,
         Quantity < 1e07,
         Gross_Cost > 500,
         Gross_Cost < 3.1e09) %>% 
  lm(formula = log10(Gross_Cost) ~ log10(Quantity))

summary(veg_model)
## 
## Call:
## lm(formula = log10(Gross_Cost) ~ log10(Quantity), data = .)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -3.5159 -0.3614 -0.0335  0.3361  2.7097 
## 
## Coefficients:
##                 Estimate Std. Error t value Pr(>|t|)    
## (Intercept)      2.58276    0.04412   58.55   <2e-16 ***
## log10(Quantity)  0.73076    0.01148   63.64   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.6577 on 2401 degrees of freedom
## Multiple R-squared:  0.6278, Adjusted R-squared:  0.6277 
## F-statistic:  4051 on 1 and 2401 DF,  p-value: < 2.2e-16

The model is significant, with a reasonable R^2 fit. We can then turn this model into a formula using the slope intercept transformation of the regression coefficients. Note: these are log(10) transformed, but the function below puts a given quantity back to a dollar amount.

veg_reg_formula <- function(Quantity){
  10^(log10(Quantity)*.73076 + 2.58276)
}

1.2.3.1 Example

dollar(veg_reg_formula(1000))
## [1] "$59,571.70"

1.2.3.2 Formula Explained

  • Slope intercept formula converted to log-log format is:
  • \(log10(Cost) = intercept + slope * log10(Quantity)\)
  • \(log10(Cost) ~= 2.583 + .731 * log10(1000)\)
  • \(59,571.70 = 2.583 + .731 * 3\)

Comparing this to the $25 per CY, where we have - \(1000*25 - 25,000\)

We can build a comparison of the model based formula v. other formulas later. There is also a possibility of adding in further correlated variables as predictors to the model formula, such as: - average (historical) project cost per county - infrastructure value per county, population per county.

1.2.3.3 Correlated Predictors (For Possible Future Iterations)

  • Not many promising predictors at the moment…
#glimpse(veg_pred.m)

cor.test(veg_pred.m$Gross_Cost, veg_pred.m$Quantity, method = "spearman")
## 
##  Spearman's rank correlation rho
## 
## data:  veg_pred.m$Gross_Cost and veg_pred.m$Quantity
## S = 446435302, p-value < 2.2e-16
## alternative hypothesis: true rho is not equal to 0
## sample estimates:
##       rho 
## 0.7568245
#rho=.75  #rank oreder corr

cor.test(log10(veg_pred.m$Gross_Cost), log10(veg_pred.m$Quantity))
## 
##  Pearson's product-moment correlation
## 
## data:  log10(veg_pred.m$Gross_Cost) and log10(veg_pred.m$Quantity)
## t = 49.936, df = 2223, p-value < 2.2e-16
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.7069106 0.7461177
## sample estimates:
##       cor 
## 0.7271065
#r = .73
mean(veg_pred.m$Quantity)
## [1] 2064069
cor.test(scale(as.numeric(veg_pred.m$Population)), log(veg_pred.m$Quantity))
## 
##  Pearson's product-moment correlation
## 
## data:  scale(as.numeric(veg_pred.m$Population)) and log(veg_pred.m$Quantity)
## t = 4.8078, df = 2223, p-value = 1.628e-06
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  0.06014428 0.14240093
## sample estimates:
##      cor 
## 0.101446
cor.test(veg_pred$RESL_SCORE, log(1+veg_pred$Quantity))
## 
##  Pearson's product-moment correlation
## 
## data:  veg_pred$RESL_SCORE and log(1 + veg_pred$Quantity)
## t = 1.1465, df = 2375, p-value = 0.2517
## alternative hypothesis: true correlation is not equal to 0
## 95 percent confidence interval:
##  -0.01670020  0.06366419
## sample estimates:
##     cor 
## 0.02352

1.3 Const-Debris

1.3.1 The Data:

Here is the Grants Manager data for construction debris removals, again aggregated to county level removals. If there are multiple projects sites for a removal, they are gathered up so each row representes a given Cat Work A - Sum of Quantity Removed and Sum of Cost of removal.

Disaster_num FIPS Dec_Date Num_Removals Num_Damages Num_Projects Gross_Cost Net_Cost Quantity year Population Infrastructure_Value RISK_SCORE RESL_SCORE disasterName incidentType region
4284 13051 2016-10-09 2 2 2 3.705885e+06 3705885.12 5.040000e+02 2016 293520 5.634188e+10 98.6636971 90.77 HURRICANE MATTHEW Hurricane 4
4344 06067 2017-10-10 2 2 2 2.887155e+06 2887155.27 1.579100e+04 2017 1584652 2.637269e+11 97.6455616 65.53 WILDFIRES Fire 9
4344 06097 2017-10-10 1 1 1 4.068530e+03 4068.53 2.000000e+00 2017 488330 1.046105e+11 99.1727649 72.98 WILDFIRES Fire 9
4337 12001 2017-09-10 5 2 2 5.910707e+06 3027397.24 1.429740e+04 2017 277984 4.273670e+10 93.8275533 74.44 HURRICANE IRMA Hurricane 4
4337 12007 2017-09-10 1 1 1 5.966274e+04 59662.74 1.400000e+02 2017 28233 3.560269e+09 70.2195355 28.39 HURRICANE IRMA Hurricane 4
4337 12009 2017-09-10 10 10 10 3.529646e+06 3529646.08 1.135205e+05 2017 606067 1.055946e+11 99.3636653 59.83 HURRICANE IRMA Hurricane 4
4337 12011 2017-09-10 16 16 16 2.210745e+07 22107450.30 4.353217e+05 2017 1940829 2.681728e+11 99.7454661 44.84 HURRICANE IRMA Hurricane 4
4337 12019 2017-09-10 8 5 5 8.039765e+06 7292302.87 1.303454e+05 2017 218078 2.936411e+10 88.7686923 57.67 HURRICANE IRMA Hurricane 4
4337 12021 2017-09-10 6 3 3 6.718732e+05 569055.77 2.136282e+05 2017 375443 8.254240e+10 98.8545975 20.15 HURRICANE IRMA Hurricane 4
4337 12027 2017-09-10 6 6 4 1.437593e+06 1437593.03 1.647947e+05 2017 33898 5.358888e+09 90.4231626 1.11 HURRICANE IRMA Hurricane 4
4337 12031 2017-09-10 7 7 7 1.364659e+06 1364659.15 2.211878e+05 2017 994675 1.584862e+11 97.8364620 67.19 HURRICANE IRMA Hurricane 4
4337 12035 2017-09-10 7 7 7 1.707548e+06 1707547.73 4.198133e+04 2017 115270 1.705646e+10 88.3550748 33.13 HURRICANE IRMA Hurricane 4
4337 12043 2017-09-10 1 1 1 5.911640e+03 5911.64 5.667340e+04 2017 12052 2.247458e+09 74.9920458 0.70 HURRICANE IRMA Hurricane 4
4337 12051 2017-09-10 1 1 1 4.305388e+05 430538.76 4.670000e+02 2017 39371 6.080710e+09 91.1549475 0.89 HURRICANE IRMA Hurricane 4
4337 12055 2017-09-10 2 2 2 1.340932e+07 13409317.59 5.263260e+04 2017 101136 1.753236e+10 90.2958956 4.81 HURRICANE IRMA Hurricane 4
4337 12057 2017-09-10 1 1 1 4.834040e+03 4834.04 2.200000e+03 2017 1458282 2.038126e+11 99.5545657 40.90 HURRICANE IRMA Hurricane 4
4337 12061 2017-09-10 2 2 2 3.078071e+05 307807.07 4.844200e+02 2017 159719 2.862201e+10 97.0728603 49.55 HURRICANE IRMA Hurricane 4
4337 12069 2017-09-10 2 2 2 6.367834e+06 6367834.33 4.258000e+03 2017 383042 5.896930e+10 95.2274897 48.09 HURRICANE IRMA Hurricane 4
4337 12071 2017-09-10 9 9 8 1.992298e+07 19922980.08 3.560657e+04 2017 759922 1.233084e+11 99.4909322 9.17 HURRICANE IRMA Hurricane 4
4337 12073 2017-09-10 9 9 9 3.198412e+07 31984115.95 1.301668e+05 2017 292157 4.688315e+10 94.5593382 74.76 HURRICANE IRMA Hurricane 4
4337 12081 2017-09-10 3 3 3 1.173623e+07 11736228.42 8.925600e+03 2017 399485 6.672028e+10 98.4409800 23.90 HURRICANE IRMA Hurricane 4
4337 12083 2017-09-10 4 1 1 1.118972e+05 55948.60 1.316000e+02 2017 375566 5.623256e+10 96.2456252 20.05 HURRICANE IRMA Hurricane 4
4337 12086 2017-09-10 28 25 24 2.112189e+07 21082923.83 1.263430e+06 2017 2698679 3.195744e+11 99.8090996 37.11 HURRICANE IRMA Hurricane 4
4337 12087 2017-09-10 17 14 13 6.142769e+07 46879999.20 8.578856e+05 2017 82390 1.808080e+10 95.9274578 27.88 HURRICANE IRMA Hurricane 4
4337 12089 2017-09-10 2 2 2 3.162066e+06 3162065.57 2.345950e+03 2017 90123 1.418695e+10 83.0734967 70.78 HURRICANE IRMA Hurricane 4
4337 12093 2017-09-10 2 2 2 1.699323e+06 1699323.41 1.455700e+03 2017 39455 6.060952e+09 87.5914731 2.42 HURRICANE IRMA Hurricane 4
4337 12095 2017-09-10 2 2 2 4.278189e+05 427818.87 4.963960e+03 2017 1428790 2.324704e+11 98.5682469 43.92 HURRICANE IRMA Hurricane 4
4337 12097 2017-09-10 3 3 3 3.820086e+05 382008.61 1.861718e+04 2017 387795 5.045786e+10 95.1320395 35.74 HURRICANE IRMA Hurricane 4
4337 12099 2017-09-10 8 8 8 2.098244e+06 2098244.25 1.612295e+04 2017 1489461 2.385678e+11 99.7136494 23.65 HURRICANE IRMA Hurricane 4
4337 12101 2017-09-10 1 1 1 1.484174e+04 14841.74 2.000000e+00 2017 561566 8.980181e+10 99.0454979 13.21 HURRICANE IRMA Hurricane 4
4337 12103 2017-09-10 16 13 13 2.622531e+07 14089979.61 1.243350e+06 2017 958822 1.452981e+11 99.2045816 12.00 HURRICANE IRMA Hurricane 4
4337 12105 2017-09-10 4 4 4 1.379514e+07 13795142.37 6.649810e+05 2017 721918 1.007445e+11 98.0273624 30.36 HURRICANE IRMA Hurricane 4
4337 12107 2017-09-10 2 2 2 3.211588e+06 3211587.80 3.044940e+04 2017 73208 1.125835e+10 90.1686287 14.23 HURRICANE IRMA Hurricane 4
4337 12109 2017-09-10 16 5 5 1.758281e+06 1524340.54 1.446476e+04 2017 273175 5.135085e+10 94.1457206 81.99 HURRICANE IRMA Hurricane 4
4337 12115 2017-09-10 1 1 1 6.948444e+04 69484.44 2.750000e+01 2017 433908 8.064207e+10 98.4091632 9.23 HURRICANE IRMA Hurricane 4
4337 12117 2017-09-10 7 4 4 1.372560e+06 1081807.04 1.974345e+04 2017 470586 7.253923e+10 95.6411072 64.58 HURRICANE IRMA Hurricane 4
4337 12127 2017-09-10 12 12 12 1.472103e+07 14721033.87 9.080085e+04 2017 551829 8.247022e+10 97.5182946 45.64 HURRICANE IRMA Hurricane 4
4338 13039 2017-09-16 4 4 4 1.249740e+06 1249740.45 5.001874e+06 2017 54619 8.633305e+09 85.3006682 57.57 HURRICANE IRMA Hurricane 4
4297 13081 2017-01-26 2 2 2 2.829343e+04 28293.43 5.210000e+01 2017 20073 4.970131e+09 61.1199491 20.75 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4294 13095 2017-01-25 2 2 2 7.084616e+06 7084615.96 1.281275e+04 2017 85747 1.924929e+10 79.5100223 54.68 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Severe Storm 4
4297 13095 2017-01-26 4677 17 3 4.188572e+08 21196961.65 1.196095e+06 2017 85747 1.924929e+10 79.5100223 54.68 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4338 13127 2017-09-16 3 3 3 7.850670e+06 7850670.10 6.964770e+03 2017 84424 1.615499e+10 90.8049634 83.99 HURRICANE IRMA Hurricane 4
4350 28047 2017-11-23 1 1 1 2.444791e+04 24447.91 7.190000e+01 2017 208275 3.732934e+10 97.2001273 67.41 HURRICANE NATE Hurricane 4
4317 29051 2017-06-02 3 3 2 3.968734e+04 39687.34 1.950000e+02 2017 76989 1.757678e+10 74.6102450 90.67 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING Flood 7
4317 29091 2017-06-02 4 1 1 1.737840e+05 86892.00 1.100000e+02 2017 39672 1.001590e+10 81.7690105 12.09 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING Flood 7
4317 29099 2017-06-02 1 1 1 3.309160e+03 3309.16 1.754891e+05 2017 226703 3.437278e+10 87.2096723 74.86 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING Flood 7
4317 29149 2017-06-02 3 3 3 1.666061e+05 166606.08 1.323305e+05 2017 8635 2.416828e+09 51.9885460 0.76 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING Flood 7
4317 29189 2017-06-02 1 1 1 1.446020e+03 1446.02 8.000000e+01 2017 1003734 2.351181e+11 98.5364302 77.66 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS AND FLOODING Flood 7
4329 33009 2017-08-09 1 1 1 3.709950e+03 3709.95 2.220000e+00 2017 91072 2.025017e+10 66.4015272 66.36 SEVERE STORMS AND FLOODING Severe Storm 1
4346 45013 2017-10-16 1 1 1 2.853906e+05 285390.56 8.880000e+02 2017 186606 4.113781e+10 98.3455297 64.10 HURRICANE IRMA Hurricane 4
4346 45019 2017-10-16 4 4 4 2.399184e+06 2399183.76 3.465800e+03 2017 407722 8.599560e+10 99.4591155 92.71 HURRICANE IRMA Hurricane 4
4332 48007 2017-08-25 4 4 4 2.847465e+06 2847465.32 1.187878e+05 2017 23703 5.141210e+09 84.5052498 46.34 HURRICANE HARVEY Hurricane 6
4332 48039 2017-08-25 9 6 5 8.219233e+06 8191287.35 1.750138e+05 2017 371474 5.751482e+10 99.1091314 71.71 HURRICANE HARVEY Hurricane 6
4332 48057 2017-08-25 1 1 1 3.777138e+05 377713.75 6.056420e+05 2017 20057 4.802417e+09 85.1415845 75.43 HURRICANE HARVEY Hurricane 6
4332 48071 2017-08-25 1 1 1 1.157696e+05 115769.57 5.000000e+03 2017 46507 1.201820e+10 89.7550111 91.88 HURRICANE HARVEY Hurricane 6
4332 48089 2017-08-25 1 1 1 1.358339e+05 135833.94 1.558000e+04 2017 20532 6.709205e+09 69.4877506 45.07 HURRICANE HARVEY Hurricane 6
4332 48091 2017-08-25 1 1 1 3.217175e+04 32171.75 1.720000e+01 2017 161300 3.132962e+10 90.3595291 76.35 HURRICANE HARVEY Hurricane 6
4332 48157 2017-08-25 3 3 3 2.123830e+05 212382.96 3.083200e+03 2017 822581 1.389588e+11 99.0773147 56.43 HURRICANE HARVEY Hurricane 6
4332 48167 2017-08-25 11 8 8 2.563490e+07 15840931.97 7.932393e+05 2017 350477 5.674698e+10 99.5227490 90.36 HURRICANE HARVEY Hurricane 6
4332 48199 2017-08-25 5 5 5 7.272911e+05 727291.13 7.928390e+04 2017 56129 1.037468e+10 83.8052816 46.50 HURRICANE HARVEY Hurricane 6
4332 48201 2017-08-25 20 20 20 4.383438e+07 43834377.28 1.439547e+06 2017 4726200 7.472565e+11 99.9681833 12.73 HURRICANE HARVEY Hurricane 6
4332 48239 2017-08-25 1 1 1 6.656425e+04 66564.25 7.638000e+03 2017 14955 6.581488e+09 88.0369074 38.03 HURRICANE HARVEY Hurricane 6
4332 48245 2017-08-25 9 6 6 1.557740e+07 15568113.41 1.105035e+06 2017 256386 3.854901e+10 97.7410118 68.01 HURRICANE HARVEY Hurricane 6
4332 48287 2017-08-25 1 1 1 6.533230e+03 6533.23 2.700000e+02 2017 17463 3.773540e+09 38.9436844 40.67 HURRICANE HARVEY Hurricane 6
4332 48291 2017-08-25 2 2 2 4.152299e+04 41522.99 1.603400e+03 2017 91492 1.026688e+10 91.6321985 25.53 HURRICANE HARVEY Hurricane 6
4332 48321 2017-08-25 3 3 3 3.178575e+05 317857.49 3.274200e+03 2017 36214 6.666911e+09 89.7868279 44.97 HURRICANE HARVEY Hurricane 6
4332 48339 2017-08-25 3 3 3 2.221158e+05 222115.80 3.736000e+03 2017 620016 9.583079e+10 96.7228762 38.57 HURRICANE HARVEY Hurricane 6
4332 48351 2017-08-25 1 1 1 1.996190e+05 199618.97 8.824000e+03 2017 12151 2.050022e+09 47.8205536 3.72 HURRICANE HARVEY Hurricane 6
4332 48355 2017-08-25 13 5 5 1.273601e+08 43605609.19 1.611233e+06 2017 352623 5.585192e+10 97.5501114 76.70 HURRICANE HARVEY Hurricane 6
4332 48361 2017-08-25 18 6 6 5.844348e+07 29451483.35 1.711566e+06 2017 84645 1.477127e+10 96.5637926 63.75 HURRICANE HARVEY Hurricane 6
4332 48373 2017-08-25 1 1 1 6.586066e+04 65860.66 3.271700e+03 2017 49569 7.639450e+09 82.2144448 18.08 HURRICANE HARVEY Hurricane 6
4332 48391 2017-08-25 1 1 1 1.233052e+05 17939.78 7.000000e+01 2017 6741 1.518277e+09 63.5062043 33.45 HURRICANE HARVEY Hurricane 6
4332 48407 2017-08-25 1 1 1 1.192560e+04 11925.60 8.800000e+02 2017 27373 4.114451e+09 76.3919822 8.88 HURRICANE HARVEY Hurricane 6
4332 48409 2017-08-25 24 6 6 1.018784e+08 36331134.66 1.297303e+06 2017 68653 1.095620e+10 89.1504932 46.56 HURRICANE HARVEY Hurricane 6
4332 48453 2017-08-25 8 5 4 2.087443e+07 18494026.05 6.116253e+06 2017 1285769 1.895386e+11 96.8819599 56.75 HURRICANE HARVEY Hurricane 6
4332 48469 2017-08-25 1 1 1 7.734620e+06 7734619.61 2.371645e+04 2017 91218 1.636339e+10 91.9503659 47.14 HURRICANE HARVEY Hurricane 6
4332 48471 2017-08-25 1 1 1 1.318225e+04 13182.25 2.692136e+06 2017 76299 1.014816e+10 80.4963411 19.29 HURRICANE HARVEY Hurricane 6
4332 48473 2017-08-25 1 1 1 8.076687e+04 80766.87 1.158000e+03 2017 56764 1.240359e+10 79.7645562 36.89 HURRICANE HARVEY Hurricane 6
4332 48481 2017-08-25 6 3 2 4.031395e+06 2056091.56 1.860052e+05 2017 41544 8.099223e+09 89.8822781 44.53 HURRICANE HARVEY Hurricane 6
4343 55023 2017-10-07 1 1 1 2.067520e+03 2067.52 2.000000e+01 2017 16088 7.987750e+09 66.1151766 72.69 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD Severe Storm 5
4343 55043 2017-10-07 1 1 1 2.295321e+04 22953.21 1.972746e+01 2017 51299 1.162080e+10 61.7562838 68.87 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD Severe Storm 5
4343 55123 2017-10-07 1 1 1 5.471690e+03 5471.69 1.200000e+02 2017 30574 7.252761e+09 51.1294941 73.93 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUD Severe Storm 5
4339 72003 2017-09-20 1 1 1 1.117674e+07 11176744.73 2.311582e+04 2017 38125 4.957845e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72013 2017-09-20 2 2 2 8.100000e+03 8100.00 1.598148e+02 2017 87581 1.190678e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72021 2017-09-20 2 2 2 1.808207e+04 18082.07 1.230600e+02 2017 184904 2.888948e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72027 2017-09-20 1 1 1 6.301887e+05 630188.73 1.266960e+04 2017 32797 3.642558e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72031 2017-09-20 7 4 4 6.085016e+05 480450.04 5.396000e+03 2017 154696 2.283049e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72045 2017-09-20 1 1 1 1.115410e+05 111541.00 1.800000e+02 2017 18883 1.969412e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72051 2017-09-20 1 1 1 7.457270e+03 7457.27 3.500000e+01 2017 35792 4.913842e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72057 2017-09-20 1 1 1 4.091200e+03 4091.20 2.280000e+02 2017 36538 5.954075e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72061 2017-09-20 1 1 1 4.304567e+06 4304566.52 1.441217e+04 2017 89604 1.653781e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72065 2017-09-20 2 2 2 1.216378e+05 109558.38 1.737360e+03 2017 38444 4.799716e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72075 2017-09-20 1 1 1 2.799388e+04 27993.88 7.000000e+01 2017 46316 4.988138e+09 NA NA HURRICANE MARIA Hurricane 2
4336 72077 2017-09-10 2 2 2 1.529488e+05 152948.79 2.349000e+03 2017 36808 4.359239e+09 NA NA HURRICANE IRMA Hurricane 2
4339 72077 2017-09-20 1 1 1 4.255565e+06 4255565.09 7.867000e+03 2017 36808 4.359239e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72085 2017-09-20 2 2 2 6.081998e+06 6081997.93 1.123299e+05 2017 35117 4.852675e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72093 2017-09-20 1 1 1 3.902432e+06 3902432.07 4.015700e+03 2017 4733 5.949854e+08 NA NA HURRICANE MARIA Hurricane 2
4336 72103 2017-09-10 2 2 2 2.336348e+05 233634.78 1.237900e+03 2017 23283 2.953017e+09 NA NA HURRICANE IRMA Hurricane 2
4339 72103 2017-09-20 1 1 1 2.970000e+04 29700.00 3.500000e+02 2017 23283 2.953017e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72105 2017-09-20 2 2 2 1.434530e+06 1434529.99 3.230785e+04 2017 29241 2.934399e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72109 2017-09-20 1 1 1 2.668247e+05 266824.67 5.347060e+03 2017 15929 2.009534e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72111 2017-09-20 2 2 2 1.212950e+06 1212950.30 9.680060e+02 2017 20320 2.518446e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72113 2017-09-20 3 3 3 7.292549e+05 729254.89 2.246476e+05 2017 137316 2.102578e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72117 2017-09-20 1 1 1 7.947540e+04 79475.40 1.572450e+03 2017 15187 2.056385e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72123 2017-09-20 1 1 1 6.136379e+05 613637.94 7.337740e+03 2017 25742 3.835226e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72127 2017-09-20 71 12 12 5.094905e+08 94516937.40 1.429344e+05 2017 341981 6.618328e+10 NA NA HURRICANE MARIA Hurricane 2
4339 72135 2017-09-20 1 1 1 8.427339e+06 8427338.70 4.862000e+03 2017 66827 6.691613e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72151 2017-09-20 1 1 1 1.692698e+06 1692698.04 2.060524e+04 2017 30397 3.345120e+09 NA NA HURRICANE MARIA Hurricane 2
4339 72153 2017-09-20 1 1 1 6.313312e+05 631331.25 5.279580e+03 2017 34151 3.045488e+09 NA NA HURRICANE MARIA Hurricane 2
4362 01015 2018-04-26 5 5 5 5.949913e+06 5949913.22 1.064080e+06 2018 116250 2.269150e+10 84.3779828 46.72 SEVERE STORMS AND TORNADOES Severe Storm 4
4362 01055 2018-04-26 1 1 1 3.005575e+05 300557.48 2.800000e+04 2018 103320 1.900045e+10 82.2462615 53.66 SEVERE STORMS AND TORNADOES Severe Storm 4
4406 01069 2018-11-05 2 2 2 5.046204e+06 5046204.31 7.605860e+03 2018 107125 2.376142e+10 90.6776965 64.00 HURRICANE MICHAEL Hurricane 4
4362 01115 2018-04-26 1 1 1 3.067902e+05 306790.20 3.200000e+02 2018 90899 1.311334e+10 70.7922367 48.50 SEVERE STORMS AND TORNADOES Severe Storm 4
4407 06007 2018-11-12 3 3 3 5.845413e+05 455216.28 2.499960e+05 2018 211490 4.251521e+10 97.1683105 62.41 WILDFIRES Fire 9
4407 06037 2018-11-12 2 2 2 1.856366e+05 185636.61 4.628601e+01 2018 10005712 1.517716e+12 100.0000000 19.67 WILDFIRES Fire 9
4382 06067 2018-08-05 1 1 1 6.605000e+07 66050000.00 9.840000e+02 2018 1584652 2.637269e+11 97.6455616 65.53 WILDFIRES AND HIGH WINDS Fire 9
4407 06067 2018-11-12 1 1 1 2.380376e+07 23803762.44 2.871600e+04 2018 1584652 2.637269e+11 97.6455616 65.53 WILDFIRES Fire 9
4353 06083 2018-01-03 4 4 2 5.495064e+06 5495064.48 1.773000e+03 2018 447998 7.845353e+10 99.3954820 47.93 WILDFIRES, FLOODING, MUDFLOWS, AND DEBRIS FLOWS Fire 9
4382 06089 2018-08-05 2 2 2 7.360249e+04 73602.49 0.000000e+00 2018 181918 3.728918e+10 95.2911231 50.95 WILDFIRES AND HIGH WINDS Fire 9
4353 06111 2018-01-03 1 1 1 5.917860e+05 591786.03 6.000000e+00 2018 843136 1.513737e+11 99.4272988 47.04 WILDFIRES, FLOODING, MUDFLOWS, AND DEBRIS FLOWS Fire 9
4407 06111 2018-11-12 1 1 1 2.299776e+05 229977.60 3.635760e+04 2018 843136 1.513737e+11 99.4272988 47.04 WILDFIRES Fire 9
4399 12005 2018-10-11 666 25 25 1.219259e+09 422451597.80 7.065869e+06 2018 174869 3.231735e+10 97.4864779 31.41 HURRICANE MICHAEL Hurricane 4
4399 12013 2018-10-11 2 2 2 3.520674e+05 352067.43 2.986000e+03 2018 13597 2.454658e+09 68.5332485 13.34 HURRICANE MICHAEL Hurricane 4
4399 12037 2018-10-11 2 2 2 1.163034e+05 116303.39 4.480000e+04 2018 12426 2.829817e+09 70.6649698 28.55 HURRICANE MICHAEL Hurricane 4
4399 12039 2018-10-11 1 1 1 1.011368e+04 10113.68 1.092592e+04 2018 43693 6.497843e+09 80.0509068 32.88 HURRICANE MICHAEL Hurricane 4
4399 12045 2018-10-11 2 2 2 1.264253e+06 1264253.34 2.760000e+03 2018 14176 2.743053e+09 76.2647152 43.22 HURRICANE MICHAEL Hurricane 4
4399 12063 2018-10-11 1 1 1 1.075691e+07 10756905.86 4.307620e+05 2018 47249 8.012107e+09 85.8097359 20.91 HURRICANE MICHAEL Hurricane 4
4399 12073 2018-10-11 116 17 17 3.972479e+08 267038661.18 1.437230e+06 2018 292157 4.688315e+10 94.5593382 74.76 HURRICANE MICHAEL Hurricane 4
4399 12123 2018-10-11 1 1 1 7.833412e+04 78334.12 2.053206e+05 2018 21690 3.630806e+09 74.0057270 16.17 HURRICANE MICHAEL Hurricane 4
4399 12133 2018-10-11 1 1 1 0.000000e+00 0.00 9.500000e+01 2018 25288 3.660356e+09 87.7187401 15.60 HURRICANE MICHAEL Hurricane 4
4400 13081 2018-10-14 1 1 1 2.558951e+05 255895.10 6.533300e+03 2018 20073 4.970131e+09 61.1199491 20.75 HURRICANE MICHAEL Hurricane 4
4400 13087 2018-10-14 1 1 1 6.251782e+06 6251782.29 1.231300e+02 2018 29305 5.487419e+09 80.7826917 18.36 HURRICANE MICHAEL Hurricane 4
4400 13095 2018-10-14 3 3 3 7.658757e+06 7658757.34 4.982200e+03 2018 85747 1.924929e+10 79.5100223 54.68 HURRICANE MICHAEL Hurricane 4
4400 13099 2018-10-14 1 1 1 2.034805e+05 203480.51 2.000000e+05 2018 10781 2.629068e+09 59.4018454 29.06 HURRICANE MICHAEL Hurricane 4
4400 13121 2018-10-14 1 1 1 3.407570e+03 3407.57 5.000000e+00 2018 1065539 2.317551e+11 92.3003500 55.28 HURRICANE MICHAEL Hurricane 4
4400 13201 2018-10-14 1 1 1 1.250563e+05 125056.33 7.968000e+02 2018 5989 1.442293e+09 45.5615654 25.08 HURRICANE MICHAEL Hurricane 4
4400 13253 2018-10-14 2 2 2 2.209354e+05 220935.38 4.762900e+03 2018 9105 2.212101e+09 62.9971365 14.99 HURRICANE MICHAEL Hurricane 4
4365 15007 2018-05-08 2 2 2 9.381912e+05 938191.17 3.730000e+02 2018 73136 1.453875e+10 74.4193446 84.85 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 9
4363 18019 2018-05-04 1 1 1 6.492410e+03 6492.41 3.000000e+02 2018 120950 2.158405e+10 81.9280942 76.16 SEVERE STORMS AND FLOODING Flood 5
4363 18061 2018-05-04 1 1 1 3.732700e+03 3732.70 9.520000e+02 2018 39636 7.284303e+09 60.1972638 45.77 SEVERE STORMS AND FLOODING Flood 5
4363 18099 2018-05-04 1 1 1 5.291750e+03 5291.75 6.130000e+02 2018 46062 1.017629e+10 42.5071588 70.59 SEVERE STORMS AND FLOODING Flood 5
4386 19119 2018-08-20 1 1 1 6.327620e+03 6327.62 6.000000e+01 2018 11934 3.533338e+09 34.2984410 85.42 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 7
4392 19127 2018-09-12 4900 1 1 1.361042e+09 19443461.10 3.486432e+05 2018 40092 1.087537e+10 68.8514158 68.52 SEVERE STORM AND TORNADOES Severe Storm 7
4386 19141 2018-08-20 1 1 1 2.628680e+04 26286.80 3.900000e+02 2018 14182 4.720749e+09 67.4196627 95.80 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 7
4386 19153 2018-08-20 4 4 4 3.565789e+05 356578.94 3.800370e+04 2018 492316 9.393685e+10 91.5367483 95.58 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 7
4392 19169 2018-09-12 1 1 1 1.682558e+05 168255.77 2.733750e+03 2018 98533 1.981740e+10 76.0101814 88.89 SEVERE STORM AND TORNADOES Severe Storm 7
4386 19191 2018-08-20 1 1 1 8.111990e+03 8111.99 2.000000e+00 2018 20051 6.671076e+09 45.1479478 95.45 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 7
4361 21111 2018-04-26 4 1 1 1.206681e+06 603340.60 9.301000e+03 2018 782833 1.432227e+11 95.9592746 77.94 SEVERE STORMS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4376 24003 2018-07-03 1 1 1 4.318837e+04 43188.37 1.209226e+04 2018 587917 9.523544e+10 92.0139994 90.01 SEVERE STORM AND FLOODING Flood 3
4376 24027 2018-07-03 1 1 1 3.857715e+05 385771.50 1.344000e+03 2018 332270 6.535684e+10 80.4008909 81.51 SEVERE STORM AND FLOODING Flood 3
4372 25009 2018-06-25 1 1 1 4.569497e+04 45694.97 9.625000e+01 2018 808897 1.504420e+11 93.9548202 96.21 SEVERE WINTER STORM AND FLOODING Severe Storm 1
4372 25021 2018-06-25 2 2 2 2.212549e+05 221254.87 2.000000e+00 2018 725648 1.489036e+11 92.9048680 93.98 SEVERE WINTER STORM AND FLOODING Severe Storm 1
4372 25023 2018-06-25 2 2 2 3.556252e+05 355625.20 9.508000e+04 2018 530320 1.025170e+11 90.9958638 99.01 SEVERE WINTER STORM AND FLOODING Severe Storm 1
4390 27101 2018-09-05 1 1 1 1.114522e+04 11145.22 6.930000e+02 2018 8175 2.988917e+09 30.7986001 93.79 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4390 27127 2018-09-05 2 2 2 3.963801e+04 39638.01 1.117750e+04 2018 15425 4.482224e+09 33.4393891 96.31 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4397 36001 2018-10-01 5 2 2 7.121837e+06 4507982.53 3.164186e+04 2018 314684 6.262032e+10 75.5011136 94.02 SEVERE STORMS AND FLOODING Flood 2
4393 37013 2018-09-14 10 7 7 8.602717e+05 826351.68 9.206397e+03 2018 44607 9.451940e+09 94.4957047 55.38 HURRICANE FLORENCE Hurricane 4
4393 37017 2018-09-14 2 2 2 1.263996e+05 126399.56 2.798560e+04 2018 29597 8.417363e+09 90.9004136 23.87 HURRICANE FLORENCE Hurricane 4
4393 37019 2018-09-14 14 14 14 1.331598e+07 13315982.85 3.588177e+05 2018 136245 2.994477e+10 97.0410436 64.93 HURRICANE FLORENCE Hurricane 4
4393 37031 2018-09-14 15 15 15 2.107035e+07 21070350.44 4.328141e+05 2018 67625 1.740755e+10 97.1046771 83.10 HURRICANE FLORENCE Hurricane 4
4393 37047 2018-09-14 5 5 5 3.406568e+05 340656.77 2.375821e+05 2018 50557 8.015801e+09 91.1231308 23.11 HURRICANE FLORENCE Hurricane 4
4393 37049 2018-09-14 15 9 9 1.337726e+07 11010303.55 8.857768e+04 2018 100042 1.736429e+10 96.4047089 65.63 HURRICANE FLORENCE Hurricane 4
4393 37051 2018-09-14 9 6 5 1.293207e+07 8203556.23 1.304293e+05 2018 334379 5.107665e+10 92.5230671 43.54 HURRICANE FLORENCE Hurricane 4
4393 37061 2018-09-14 3 3 3 1.489586e+05 148958.59 3.223786e+05 2018 48624 8.582202e+09 93.3821190 8.34 HURRICANE FLORENCE Hurricane 4
4393 37103 2018-09-14 1 1 1 3.056677e+05 305667.65 3.340000e+02 2018 9165 1.485431e+09 79.9872733 20.34 HURRICANE FLORENCE Hurricane 4
4393 37107 2018-09-14 1 1 1 9.623538e+05 962353.75 1.269900e+03 2018 55112 1.175561e+10 91.7912822 52.51 HURRICANE FLORENCE Hurricane 4
4393 37129 2018-09-14 6 6 6 1.647612e+07 16476124.28 5.290670e+04 2018 225344 5.126031e+10 98.5046134 82.27 HURRICANE FLORENCE Hurricane 4
4393 37133 2018-09-14 6 6 6 1.492910e+07 14929098.44 3.615121e+05 2018 202949 3.015480e+10 97.9319122 63.18 HURRICANE FLORENCE Hurricane 4
4393 37135 2018-09-14 1 1 1 5.106464e+04 51064.64 1.284000e+03 2018 148579 2.699894e+10 72.9557747 65.05 HURRICANE FLORENCE Hurricane 4
4393 37137 2018-09-14 4 4 4 3.062022e+06 3062021.80 3.502578e+04 2018 12213 3.222184e+09 84.7916004 61.23 HURRICANE FLORENCE Hurricane 4
4393 37141 2018-09-14 3 3 3 1.238024e+07 12380244.98 1.804919e+05 2018 60195 1.105170e+10 94.0184537 56.87 HURRICANE FLORENCE Hurricane 4
4393 37151 2018-09-14 1 1 1 2.812469e+04 28124.69 7.353600e+02 2018 144115 2.604142e+10 75.8510977 33.35 HURRICANE FLORENCE Hurricane 4
4393 37155 2018-09-14 5 5 5 2.722674e+06 2705433.90 4.252400e+04 2018 116414 1.841898e+10 94.3684378 12.64 HURRICANE FLORENCE Hurricane 4
4393 37163 2018-09-14 2 2 2 6.604271e+04 66042.71 2.400000e+02 2018 59021 1.256312e+10 93.9866370 11.55 HURRICANE FLORENCE Hurricane 4
4393 37183 2018-09-14 8 8 8 1.247636e+07 12476355.53 2.431282e+05 2018 1128357 2.152861e+11 93.6366529 72.02 HURRICANE FLORENCE Hurricane 4
4393 37191 2018-09-14 3 3 3 7.201412e+04 72014.12 4.823320e+03 2018 116680 2.717472e+10 94.4320713 44.11 HURRICANE FLORENCE Hurricane 4
4360 39061 2018-04-17 1 1 1 7.130350e+03 7130.35 1.800000e+02 2018 830623 1.538887e+11 93.4457525 86.31 SEVERE STORMS, LANDSLIDES, AND MUDSLIDES Flood 5
4408 42015 2018-11-27 1 1 1 3.639055e+04 36390.55 1.970060e+04 2018 59840 1.440289e+10 71.5240216 64.96 SEVERE STORMS AND FLOODING Severe Storm 3
4408 42037 2018-11-27 1 1 1 4.833000e+03 4833.00 1.464000e+03 2018 64676 1.272554e+10 36.3665288 86.03 SEVERE STORMS AND FLOODING Severe Storm 3
4394 45051 2018-09-16 5 5 5 1.133269e+06 1133268.54 2.318340e+04 2018 348574 6.455071e+10 98.9818645 61.30 HURRICANE FLORENCE Hurricane 4
4394 45067 2018-09-16 1 1 1 3.117154e+05 311715.36 8.890000e+02 2018 29137 6.028669e+09 85.9688196 22.53 HURRICANE FLORENCE Hurricane 4
4394 45069 2018-09-16 2 2 2 3.618326e+05 361832.64 8.050788e+05 2018 26656 3.804431e+09 65.6379255 17.79 HURRICANE FLORENCE Hurricane 4
4394 45079 2018-09-16 1 1 1 3.803872e+05 380387.21 1.033740e+04 2018 415644 8.168495e+10 93.3503023 74.19 HURRICANE FLORENCE Hurricane 4
4411 51760 2018-12-18 1 1 1 2.351660e+03 2351.66 2.000000e+01 2018 226269 4.353533e+10 73.2421254 54.84 TROPICAL STORM MICHAEL Hurricane 3
4383 55025 2018-08-10 1 1 1 2.871043e+04 28710.43 9.000000e+01 2018 561270 1.345952e+11 90.7413299 98.28 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4402 55025 2018-10-18 1 1 1 8.192215e+04 81922.15 3.497000e+02 2018 561270 1.345952e+11 90.7413299 98.28 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES Flood 5
4402 55077 2018-10-18 1 1 1 9.180000e+03 9180.00 3.600000e+02 2018 15562 4.275948e+09 24.3716195 56.30 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES Flood 5
4402 55081 2018-10-18 1 1 1 3.639500e+03 3639.50 1.767480e+03 2018 46230 1.119403e+10 62.1380846 72.15 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES Flood 5
4402 55111 2018-10-18 2 2 2 2.592182e+04 25921.82 1.745324e+04 2018 65699 1.686294e+10 59.6245625 89.78 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES Flood 5
4402 55123 2018-10-18 1 1 1 4.997230e+03 4997.23 2.300000e+02 2018 30574 7.252761e+09 51.1294941 73.93 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, FLOODING, AND LANDSLIDES Flood 5
4426 01019 2019-04-17 1 1 1 4.766280e+03 4766.28 8.576000e+02 2019 24933 4.433991e+09 42.0617245 13.59 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 4
4426 01059 2019-04-17 1 1 1 2.113192e+04 21131.92 1.499885e+00 2019 31999 5.620840e+09 65.4788419 19.10 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 4
4419 01081 2019-03-05 4 1 1 1.255144e+07 6275717.54 3.364800e+02 2019 173871 2.952116e+10 70.8240535 46.66 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 4
4413 02020 2019-01-31 4 4 4 5.578337e+05 557220.97 7.816600e+04 2019 290985 6.439078e+10 94.8456888 51.08 EARTHQUAKE Earthquake 10
4413 02122 2019-01-31 1 1 1 1.373895e+04 13738.95 2.800000e+01 2019 58731 1.887690e+10 90.9640471 10.38 EARTHQUAKE Earthquake 10
4441 05069 2019-06-08 1 1 1 9.373240e+03 9373.24 1.800000e+01 2019 67108 1.350750e+10 84.2507159 50.64 SEVERE STORMS AND FLOODING Flood 6
4441 05105 2019-06-08 1 1 1 4.917481e+04 49174.81 2.261666e+04 2019 10019 1.476877e+09 40.7572383 19.45 SEVERE STORMS AND FLOODING Flood 6
4441 05119 2019-06-08 4 1 1 7.177875e+05 358893.74 1.010320e+05 2019 398830 7.392333e+10 95.0684060 73.68 SEVERE STORMS AND FLOODING Flood 6
4441 05131 2019-06-08 2 2 2 3.248890e+05 324888.95 5.230000e+03 2019 127706 2.475716e+10 83.9325485 42.52 SEVERE STORMS AND FLOODING Flood 6
4434 06007 2019-05-18 1 1 1 1.030990e+05 103099.04 2.000000e+00 2019 211490 4.251521e+10 97.1683105 62.41 SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 9
4431 06065 2019-05-01 1 1 1 6.413386e+04 64133.86 8.000000e+00 2019 2416838 4.187359e+11 99.9363665 27.43 SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 9
4434 06097 2019-05-18 1 1 1 1.316370e+04 13163.70 7.200000e+02 2019 488330 1.046105e+11 99.1727649 72.98 SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 9
4443 16049 2019-06-12 1 1 1 3.722360e+03 3722.36 6.000000e+01 2019 16440 6.597193e+09 80.9099586 16.84 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4461 17149 2019-09-19 1 1 1 1.559100e+02 155.91 3.000000e+00 2019 14724 1.604249e+09 18.5173401 53.91 SEVERE STORMS AND FLOODING Flood 5
4461 17167 2019-09-19 1 1 1 3.298103e+05 329810.35 3.992000e+01 2019 196182 5.681118e+10 88.5459752 91.31 SEVERE STORMS AND FLOODING Flood 5
4461 17171 2019-09-19 4 1 1 2.268457e+05 113422.86 2.740000e+03 2019 4937 4.463794e+08 7.9541839 73.71 SEVERE STORMS AND FLOODING Flood 5
4421 19017 2019-03-23 1 1 1 2.409320e+04 24093.20 7.230000e+02 2019 24970 6.061426e+09 38.3391664 99.20 SEVERE STORMS AND FLOODING Flood 7
4421 19071 2019-03-23 35348 2 2 6.892466e+09 36853128.84 6.315800e+05 2019 6605 2.092445e+09 38.1800827 64.19 SEVERE STORMS AND FLOODING Flood 7
4421 19085 2019-03-23 1 1 1 4.015405e+04 40154.05 2.400000e+03 2019 14559 3.415922e+09 49.4432071 75.33 SEVERE STORMS AND FLOODING Flood 7
4421 19129 2019-03-23 51 3 3 8.031916e+06 1194916.74 2.314703e+03 2019 14475 3.454378e+09 38.7527840 86.28 SEVERE STORMS AND FLOODING Flood 7
4421 19163 2019-03-23 1 1 1 1.460323e+04 14603.23 1.093400e+04 2019 174636 3.898570e+10 82.0553611 95.74 SEVERE STORMS AND FLOODING Flood 7
4421 19193 2019-03-23 1 1 1 2.911463e+04 29114.63 4.920000e+02 2019 105853 1.931667e+10 83.4552975 93.57 SEVERE STORMS AND FLOODING Flood 7
4449 20015 2019-06-20 1 1 1 3.870808e+04 38708.08 9.600000e+01 2019 67340 1.296721e+10 80.2099905 70.88 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20017 2019-06-20 1 1 1 7.503620e+03 7503.62 3.000000e+01 2019 2564 8.990594e+08 25.1352211 45.45 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20035 2019-06-20 1 1 1 1.308647e+05 130864.71 7.680000e+02 2019 34541 7.569744e+09 74.5466115 70.62 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20045 2019-06-20 1 1 1 5.426368e+05 542636.85 1.463560e+03 2019 118666 2.450489e+10 79.6372892 79.79 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20047 2019-06-20 1 1 1 3.323396e+04 33233.96 3.240000e+02 2019 2905 1.061872e+09 16.0038180 50.57 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20103 2019-06-20 10 2 2 1.713647e+06 804904.23 1.475522e+04 2019 81853 1.587767e+10 74.1966274 73.81 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4449 20165 2019-06-20 1 1 1 3.980870e+03 3980.87 1.999800e+04 2019 2952 1.656550e+09 23.6080178 82.69 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING,LANDSLIDES,AND MUDSLIDES Severe Storm 7
4458 22007 2019-08-27 1 1 1 1.031278e+05 103127.79 1.022700e+03 2019 21017 3.291188e+09 86.3506204 48.89 HURRICANE BARRY Hurricane 6
4458 22033 2019-08-27 4 1 1 2.469997e+06 1234998.62 2.822000e+03 2019 456512 1.120657e+11 98.8864143 60.09 HURRICANE BARRY Hurricane 6
4439 22061 2019-06-03 3 3 2 8.330467e+05 833046.71 4.647900e+04 2019 48370 8.006832e+09 68.6605154 40.74 SEVERE STORMS AND TORNADOES Severe Storm 6
4458 22075 2019-08-27 1 1 1 3.609046e+04 36090.46 2.000000e+00 2019 23448 4.870262e+09 82.6916958 94.33 HURRICANE BARRY Hurricane 6
4458 22101 2019-08-27 1 1 1 5.739858e+05 573985.77 2.000000e+00 2019 49313 1.172348e+10 94.7184219 78.13 HURRICANE BARRY Hurricane 6
4458 22109 2019-08-27 1 1 1 6.443827e+05 644382.71 1.625000e+03 2019 109484 2.195670e+10 96.3728921 94.75 HURRICANE BARRY Hurricane 6
4442 27013 2019-06-12 1 1 1 1.025361e+04 10253.61 2.612800e+04 2019 69073 1.557987e+10 68.0559975 98.76 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4442 27027 2019-06-12 1 1 1 2.259967e+04 22599.67 1.000000e+01 2019 65291 1.448070e+10 58.6700605 85.74 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4414 27137 2019-02-01 1 1 1 2.187556e+05 218755.60 2.027750e+03 2019 200067 5.200865e+10 66.5287941 98.73 SEVERE STORMS AND FLOODING Flood 5
4442 27173 2019-06-12 1 1 1 7.070390e+03 7070.39 4.980000e+01 2019 9528 2.993936e+09 24.6579701 94.14 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4450 28023 2019-06-20 1 1 1 1.185000e+04 11850.00 1.170000e+02 2019 15570 2.563118e+09 50.6522431 21.16 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4415 28035 2019-02-14 1 1 1 1.032558e+04 10325.58 3.600000e+02 2019 78050 1.342654e+10 86.5415208 59.10 SEVERE STORMS, FLOODING, AND TORNADO Severe Storm 4
4470 28081 2019-12-06 1 1 1 2.390359e+05 239035.94 1.610000e+03 2019 83269 1.698476e+10 79.0009545 62.38 SEVERE STORM, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4429 28087 2019-04-23 2 2 2 7.591174e+05 759117.40 4.321300e+03 2019 58845 1.178985e+10 77.6328349 56.91 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 4
4450 28095 2019-06-20 1 1 1 2.144422e+06 2144422.14 8.078800e+03 2019 34055 5.885635e+09 63.0607700 43.76 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4429 28163 2019-04-23 1 1 1 4.868720e+03 4868.72 4.940000e+04 2019 26703 3.860836e+09 71.7149220 7.45 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 4
4435 29005 2019-05-20 20 2 2 1.077995e+06 312080.06 6.880000e+01 2019 5305 1.510889e+09 30.2258988 66.77 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4451 29009 2019-07-09 1 1 1 1.475490e+04 14754.90 1.199908e+04 2019 34451 8.444012e+09 77.9510022 22.69 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4435 29021 2019-05-20 4 1 1 3.153960e+04 15769.80 1.518520e+01 2019 84731 1.765838e+10 69.3923003 89.50 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4451 29033 2019-07-09 1 1 1 1.624925e+05 162492.50 6.131000e+03 2019 8482 2.270868e+09 42.4117086 77.08 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29041 2019-07-09 2 2 2 4.824655e+04 48246.55 3.670000e+02 2019 7366 2.765102e+09 21.5717467 72.12 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4435 29051 2019-05-20 1 1 1 4.047692e+04 40476.92 8.000000e+01 2019 76989 1.757678e+10 74.6102450 90.67 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4451 29051 2019-07-09 4 4 4 1.755094e+06 1755093.68 3.000406e+06 2019 76989 1.757678e+10 74.6102450 90.67 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4435 29087 2019-05-20 1 1 1 4.245427e+04 42454.27 2.581000e+03 2019 4210 1.812408e+09 23.4171174 63.34 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4451 29087 2019-07-09 1 1 1 3.051100e+04 30511.00 3.940000e+01 2019 4210 1.812408e+09 23.4171174 63.34 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29095 2019-07-09 1 1 1 1.300000e+04 13000.00 5.000000e+02 2019 716764 1.359077e+11 95.6092905 61.52 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29097 2019-07-09 1 1 1 1.910665e+05 191066.47 2.040000e+02 2019 122722 2.462236e+10 84.6961502 57.80 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29113 2019-07-09 2 2 2 3.299964e+04 32999.64 2.160000e+03 2019 59458 1.051751e+10 73.1148584 78.49 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29131 2019-07-09 1 1 1 3.319481e+04 33194.81 8.162275e+01 2019 24682 6.380061e+09 60.8017817 36.95 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29145 2019-07-09 1 1 1 1.335495e+04 13354.95 2.440000e+02 2019 58493 1.241102e+10 81.8008272 44.56 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29163 2019-07-09 1 1 1 8.439171e+04 84391.71 2.000000e+02 2019 17548 4.436404e+09 41.1708559 56.94 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29177 2019-07-09 4 1 1 1.927000e+05 96350.00 7.666666e+02 2019 23141 4.416857e+09 30.0668151 78.58 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29183 2019-07-09 2 2 2 1.358411e+06 1032853.07 8.800000e+02 2019 405183 8.092181e+10 93.0003182 96.24 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4451 29195 2019-07-09 1 1 1 1.200000e+04 12000.00 6.920000e+02 2019 23279 4.980690e+09 46.4842507 72.66 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 7
4420 31015 2019-03-21 36 1 1 4.304275e+05 71737.92 1.764000e+03 2019 1810 8.006031e+08 5.4088451 42.65 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31019 2019-03-21 1 1 1 2.907830e+04 29078.30 2.000000e+00 2019 50007 1.014431e+10 79.4463888 75.59 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31023 2019-03-21 1 1 1 1.585415e+05 158541.48 3.029140e+04 2019 8354 2.690794e+09 38.5618836 80.78 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31027 2019-03-21 2 2 2 8.846910e+03 8846.91 2.724560e+03 2019 8361 2.960310e+09 32.8985046 55.51 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31053 2019-03-21 2 2 2 3.373705e+05 337370.49 5.356880e+03 2019 37166 8.678864e+09 79.4782055 84.31 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31055 2019-03-21 3 3 3 5.094115e+05 509411.54 8.864000e+03 2019 584427 1.025738e+11 95.6729240 82.78 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31079 2019-03-21 1 1 1 5.773112e+04 57731.12 1.006000e+03 2019 62826 1.107112e+10 84.2825326 69.26 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31093 2019-03-21 1 1 1 1.283799e+04 12837.99 3.290060e+02 2019 6475 1.721276e+09 52.1476297 56.11 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31097 2019-03-21 1 1 1 4.448106e+04 44481.06 8.000000e+00 2019 5288 1.325388e+09 13.6493796 67.85 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31107 2019-03-21 1 1 1 2.877048e+04 28770.48 1.500000e+02 2019 8383 3.127981e+09 35.8574610 47.71 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31127 2019-03-21 125 2 2 4.036525e+07 4174301.65 5.708050e+03 2019 7072 1.812901e+09 24.4670697 66.61 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31139 2019-03-21 1 1 1 1.810620e+04 18106.20 1.146000e+03 2019 7312 2.229682e+09 19.5991091 73.39 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31141 2019-03-21 2 2 2 1.167394e+04 11673.94 2.920000e+03 2019 34261 7.898105e+09 75.2465797 67.03 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4420 31153 2019-03-21 3 3 3 1.905860e+05 190585.96 2.621230e+03 2019 190379 3.342189e+10 88.1641744 91.50 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, AND FLOODING Flood 7
4472 36043 2019-12-19 2 2 2 7.956687e+04 79566.87 2.690000e+02 2019 60103 1.338981e+10 34.7438753 84.40 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 2
4472 36065 2019-12-19 1 1 1 6.987899e+04 69878.99 7.116400e+02 2019 232037 4.466933e+10 72.0330894 89.62 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 2
4472 36075 2019-12-19 1 1 1 1.467824e+04 14678.24 1.578900e+04 2019 117511 2.311243e+10 28.7305122 83.67 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 2
4465 37031 2019-10-04 1 1 1 1.620020e+05 162002.05 3.329200e+04 2019 67625 1.740755e+10 97.1046771 83.10 HURRICANE DORIAN Hurricane 4
4465 37049 2019-10-04 2 2 2 4.245355e+05 424535.48 7.320000e+04 2019 100042 1.736429e+10 96.4047089 65.63 HURRICANE DORIAN Hurricane 4
4412 37055 2019-01-31 5 5 5 2.888472e+05 288847.15 4.965800e+03 2019 36860 1.259747e+10 95.4820235 99.59 TROPICAL STORM MICHAEL Hurricane 4
4465 37055 2019-10-04 5 5 5 3.087902e+06 3087902.38 9.388458e+04 2019 36860 1.259747e+10 95.4820235 99.59 HURRICANE DORIAN Hurricane 4
4465 37095 2019-10-04 1 1 1 3.121502e+06 3121502.49 4.666667e+03 2019 4573 1.146907e+09 82.5962456 35.84 HURRICANE DORIAN Hurricane 4
4465 37107 2019-10-04 1 1 1 1.053932e+04 10539.32 7.128000e+03 2019 55112 1.175561e+10 91.7912822 52.51 HURRICANE DORIAN Hurricane 4
4465 37177 2019-10-04 1 1 1 8.772494e+05 877249.43 9.887500e+02 2019 3245 1.018921e+09 74.2920776 39.12 HURRICANE DORIAN Hurricane 4
4412 37183 2019-01-31 2 2 2 1.348062e+06 1348061.53 3.384440e+03 2019 1128357 2.152861e+11 93.6366529 72.02 TROPICAL STORM MICHAEL Hurricane 4
4465 37183 2019-10-04 1 1 1 8.650087e+05 865008.67 1.400000e+04 2019 1128357 2.152861e+11 93.6366529 72.02 HURRICANE DORIAN Hurricane 4
4447 39057 2019-06-18 1 1 1 3.769586e+04 37695.86 5.000000e+00 2019 167939 3.290457e+10 64.2061724 87.49 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE Tornado 5
4447 39107 2019-06-18 1 1 1 2.019599e+04 20195.99 1.232000e+02 2019 42522 1.348284e+10 57.6519249 97.33 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE Tornado 5
4447 39113 2019-06-18 8 8 8 2.472149e+06 2472148.94 6.668112e+04 2019 537193 9.945173e+10 86.0960865 76.00 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDE Tornado 5
4438 40017 2019-06-01 1 1 1 8.616910e+03 8616.91 6.840000e+02 2019 153947 2.257507e+10 87.7823735 69.06 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40101 2019-06-01 3 3 3 2.644650e+05 264465.01 3.467000e+03 2019 66200 1.142326e+10 83.1689469 40.48 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40109 2019-06-01 1 1 1 8.379840e+04 83798.40 1.000000e+01 2019 795336 1.289742e+11 97.2637607 45.86 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40113 2019-06-01 2 2 2 2.286860e+04 22868.60 8.850000e+02 2019 45705 6.963588e+09 73.7511931 37.14 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40131 2019-06-01 1 1 1 3.210613e+04 32106.13 5.700000e+02 2019 95011 1.477543e+10 80.5281578 65.12 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40135 2019-06-01 1 1 1 8.789225e+04 87892.25 4.500000e+03 2019 39237 4.932920e+09 77.0601336 7.10 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4438 40143 2019-06-01 2 2 2 3.772521e+05 377252.08 5.694400e+02 2019 668481 1.157878e+11 96.6274260 53.69 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 6
4452 41059 2019-07-09 2 2 2 5.186247e+04 51862.47 1.744720e+03 2019 79888 1.861261e+10 76.5510659 23.52 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4464 45051 2019-09-30 1 1 1 1.850597e+05 185059.66 6.648000e+03 2019 348574 6.455071e+10 98.9818645 61.30 HURRICANE DORIAN Hurricane 4
4440 46035 2019-06-07 1 1 1 6.642263e+04 66422.63 4.440000e+02 2019 19950 5.204129e+09 63.6334712 87.78 SEVERE WINTER STORM, SNOWSTORM, AND FLOODING Flood 8
4469 46061 2019-11-18 1 1 1 4.040610e+03 4040.61 2.100000e+02 2019 3461 1.064278e+09 12.7903277 96.02 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 8
4440 46065 2019-06-07 1 1 1 7.311930e+04 73119.30 2.600000e+02 2019 17751 3.816304e+09 47.1205854 85.90 SEVERE WINTER STORM, SNOWSTORM, AND FLOODING Flood 8
4469 46087 2019-11-18 1 1 1 9.704700e+03 9704.70 5.400000e+02 2019 5682 1.196086e+10 69.1059497 88.70 SEVERE STORMS, TORNADOES, AND FLOODING Severe Storm 8
4440 46099 2019-06-07 1 1 1 1.320918e+05 132091.75 1.093400e+04 2019 196891 3.733547e+10 92.5867006 93.13 SEVERE WINTER STORM, SNOWSTORM, AND FLOODING Flood 8
4427 47071 2019-04-17 2 2 2 7.440183e+04 74401.83 1.376620e+03 2019 26745 4.834413e+09 52.4021635 34.09 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4427 47093 2019-04-17 1 1 1 1.079972e+04 10799.72 3.140000e+02 2019 478842 8.234800e+10 89.4368438 62.22 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4471 47125 2019-12-06 1 1 1 1.461950e+06 1461949.54 6.600000e+01 2019 220041 3.013971e+10 85.5870188 50.54 SEVERE STORM AND STRAIGHT-LINE WINDS Severe Storm 4
4427 47143 2019-04-17 1 1 1 2.096225e+04 20962.25 1.600000e+02 2019 32839 5.385350e+09 49.1250398 34.88 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4416 48053 2019-02-25 2 2 2 2.982315e+05 298231.52 5.002000e+03 2019 48986 9.610927e+09 80.1463570 42.39 SEVERE STORMS AND FLOODING Flood 6
4416 48207 2019-02-25 1 1 1 4.967730e+03 4967.73 2.790000e+01 2019 5414 2.023697e+09 23.1307668 20.24 SEVERE STORMS AND FLOODING Flood 6
4416 48267 2019-02-25 1 1 1 1.224471e+04 12244.71 1.900000e+01 2019 4271 2.532014e+09 46.0388164 21.29 SEVERE STORMS AND FLOODING Flood 6
4416 48271 2019-02-25 1 1 1 3.613436e+04 36134.36 3.330000e+02 2019 3126 5.383794e+08 1.5590200 1.05 SEVERE STORMS AND FLOODING Flood 6
4416 48299 2019-02-25 2 2 2 1.316702e+06 1316701.55 6.616000e+03 2019 21199 5.462515e+09 68.5650652 19.92 SEVERE STORMS AND FLOODING Flood 6
4416 48453 2019-02-25 2 2 2 3.416851e+05 341685.14 7.812000e+02 2019 1285769 1.895386e+11 96.8819599 56.75 SEVERE STORMS AND FLOODING Flood 6
4418 53009 2019-03-04 1 1 1 1.171479e+04 11714.79 2.000000e+01 2019 77054 1.511825e+10 87.4960229 56.37 SEVERE WINTER STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, MUDSLIDES, TORNADO Severe Storm 10
4563 01003 2020-09-20 17 17 16 6.077548e+07 60775477.28 3.868044e+05 2020 231365 4.596848e+10 97.7091950 86.12 HURRICANE SALLY Hurricane 4
4554 01037 2020-07-10 1 1 1 1.173505e+04 1000.00 2.200000e+02 2020 10320 1.954999e+09 7.5087496 21.71 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4554 01041 2020-07-10 1 1 1 1.267207e+05 126720.69 2.880000e+02 2020 13179 2.563555e+09 46.2615336 21.20 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4555 01055 2020-07-10 1 1 1 3.220261e+05 322026.12 7.111200e+04 2020 103320 1.900045e+10 82.2462615 53.66 SEVERE THUNDERSTORMS Severe Storm 4
4555 01095 2020-07-10 1 1 1 3.102030e+05 310203.01 5.422000e+03 2020 97552 1.736259e+10 85.1734012 40.39 SEVERE THUNDERSTORMS Severe Storm 4
4563 01097 2020-09-20 6 6 6 1.465248e+07 14652476.51 6.677400e+04 2020 414514 7.602302e+10 98.7909640 74.60 HURRICANE SALLY Hurricane 4
4573 01097 2020-12-10 2 2 2 6.170848e+06 6170848.44 4.713560e+04 2020 414514 7.602302e+10 98.7909640 74.60 HURRICANE ZETA Hurricane 4
4563 01101 2020-09-20 1 1 1 1.361660e+07 13616603.44 6.238100e+04 2020 228847 4.622347e+10 86.2551702 67.92 HURRICANE SALLY Hurricane 4
4573 01101 2020-12-10 1 1 1 6.884084e+06 6884084.00 3.200000e+01 2020 228847 4.622347e+10 86.2551702 67.92 HURRICANE ZETA Hurricane 4
4554 01109 2020-07-10 1 1 1 3.247833e+05 324783.32 1.250000e+04 2020 32965 6.512703e+09 63.2516704 49.52 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4544 05031 2020-05-08 1 1 1 3.296069e+05 229606.89 1.046000e+03 2020 111202 1.973483e+10 92.3321667 52.10 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Tornado 6
4556 05107 2020-07-10 1 1 1 1.386589e+05 138658.92 1.200000e+02 2020 16523 3.246568e+09 65.2879415 32.27 SEVERE STORMS AND STRAIGHT-LINE WINDS Tornado 6
4544 05119 2020-05-08 1 1 1 5.737772e+04 57377.72 2.470000e+03 2020 398830 7.392333e+10 95.0684060 73.68 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Tornado 6
4558 06053 2020-08-22 1 1 1 1.490270e+03 1490.27 4.000000e+01 2020 438599 7.640694e+10 98.3773465 28.90 WILDFIRES Fire 9
4558 06107 2020-08-22 1 1 1 1.269005e+04 12690.05 1.069444e+05 2020 472585 7.447368e+10 95.7683742 12.83 WILDFIRES Fire 9
4566 10001 2020-10-02 1 1 1 4.155000e+04 41550.00 1.069444e+05 2020 181705 3.268465e+10 84.7597836 72.95 TROPICAL STORM ISAIAS Hurricane 3
4566 10003 2020-10-02 1 1 1 3.055757e+05 305575.72 0.000000e+00 2020 570089 1.221791e+11 90.7731467 83.26 TROPICAL STORM ISAIAS Hurricane 3
4564 12033 2020-09-23 3 3 3 2.909541e+07 29095409.43 2.338336e+05 2020 321367 5.111437e+10 97.8682787 45.51 HURRICANE SALLY Hurricane 4
4564 12091 2020-09-23 2 2 2 3.797345e+05 379734.48 1.500740e+04 2020 211293 3.597393e+10 97.4228444 45.23 HURRICANE SALLY Hurricane 4
4564 12113 2020-09-23 5 5 5 1.126164e+07 11261636.35 1.832020e+05 2020 187714 2.541006e+10 95.5138403 53.44 HURRICANE SALLY Hurricane 4
4557 19011 2020-08-17 5 5 5 9.713339e+05 831333.87 9.875060e+03 2020 25558 6.813448e+09 48.2978046 96.63 SEVERE STORMS Severe Storm 7
4557 19091 2020-08-17 1 1 1 4.134500e+04 41345.00 3.083050e+05 2020 9597 2.200834e+09 29.6531976 84.66 SEVERE STORMS Severe Storm 7
4557 19113 2020-08-17 10 10 10 3.943399e+07 39044990.73 3.049568e+05 2020 230253 4.843057e+10 91.7276487 99.24 SEVERE STORMS Severe Storm 7
4557 19127 2020-08-17 1 1 1 2.989031e+04 29890.31 6.166100e+05 2020 40092 1.087537e+10 68.8514158 68.52 SEVERE STORMS Severe Storm 7
4557 19153 2020-08-17 1 1 1 1.364581e+05 136458.10 5.170000e+03 2020 492316 9.393685e+10 91.5367483 95.58 SEVERE STORMS Severe Storm 7
4557 19169 2020-08-17 1 1 1 2.224314e+05 143431.44 8.834000e+01 2020 98533 1.981740e+10 76.0101814 88.89 SEVERE STORMS Severe Storm 7
4557 19171 2020-08-17 1 1 1 1.856669e+06 1831668.66 1.224500e+03 2020 17081 4.591618e+09 52.7203309 72.60 SEVERE STORMS Severe Storm 7
4561 19171 2020-09-10 4 1 1 4.090607e+06 2045303.40 9.537600e+02 2020 17081 4.591618e+09 52.7203309 72.60 SEVERE STORMS AND STRAIGHT-LINE WINDS Severe Storm 7
4559 22001 2020-08-28 5 2 2 6.386554e+06 3916511.30 1.418255e+04 2020 57475 1.082074e+10 90.5186128 29.76 HURRICANE LAURA Hurricane 6
4559 22003 2020-08-28 5 5 5 1.616527e+07 16165273.67 1.394995e+04 2020 22708 3.900954e+09 64.0470888 30.68 HURRICANE LAURA Hurricane 6
4559 22011 2020-08-28 2 2 2 1.026766e+07 10267664.01 7.287010e+04 2020 36508 6.482271e+09 71.8421890 32.24 HURRICANE LAURA Hurricane 6
4559 22019 2020-08-28 44 35 35 6.907878e+08 555991104.37 5.851407e+06 2020 216652 4.227924e+10 96.9137766 32.40 HURRICANE LAURA Hurricane 6
4559 22023 2020-08-28 10 4 4 1.295674e+08 64864742.74 1.603246e+06 2020 5615 1.108910e+09 55.8065542 95.04 HURRICANE LAURA Hurricane 6
4559 22033 2020-08-28 18 6 6 2.262258e+08 116704985.16 6.778400e+05 2020 456512 1.120657e+11 98.8864143 60.09 HURRICANE LAURA Hurricane 6
4570 22033 2020-10-16 1 1 1 2.712772e+05 271277.18 5.800000e+01 2020 456512 1.120657e+11 98.8864143 60.09 HURRICANE DELTA Hurricane 6
4559 22043 2020-08-28 2 2 2 1.588890e+07 15888904.87 4.963000e+03 2020 22122 3.090163e+09 33.6939230 20.78 HURRICANE LAURA Hurricane 6
4559 22053 2020-08-28 7 7 7 7.302015e+06 7302015.49 3.913800e+04 2020 32235 5.698292e+09 88.4505250 30.11 HURRICANE LAURA Hurricane 6
4559 22055 2020-08-28 1 1 1 6.092992e+04 60929.92 2.462600e+04 2020 241618 4.511250e+10 97.9637289 64.35 HURRICANE LAURA Hurricane 6
4570 22055 2020-10-16 6 6 6 7.435385e+06 7435385.23 9.698600e+03 2020 241618 4.511250e+10 97.9637289 64.35 HURRICANE DELTA Hurricane 6
4559 22073 2020-08-28 3 3 3 3.422428e+06 3422427.84 1.416077e+04 2020 160298 2.846186e+10 85.6188355 69.29 HURRICANE LAURA Hurricane 6
4559 22079 2020-08-28 1 1 1 4.254576e+06 4254575.96 5.706400e+03 2020 129664 2.330566e+10 83.3916640 71.26 HURRICANE LAURA Hurricane 6
4570 22079 2020-10-16 1 1 1 7.058359e+04 70583.59 2.468800e+02 2020 129664 2.330566e+10 83.3916640 71.26 HURRICANE DELTA Hurricane 6
4570 22099 2020-10-16 2 2 2 8.980032e+05 898003.24 7.142000e+02 2020 51686 8.428679e+09 91.3140312 75.75 HURRICANE DELTA Hurricane 6
4559 22113 2020-08-28 2 2 2 6.045695e+06 6045694.95 2.477365e+04 2020 57317 7.237194e+09 89.8504613 70.69 HURRICANE LAURA Hurricane 6
4570 22113 2020-10-16 1 1 1 6.183000e+03 6183.00 7.000000e+00 2020 57317 7.237194e+09 89.8504613 70.69 HURRICANE DELTA Hurricane 6
4559 22115 2020-08-28 6 3 3 1.323466e+07 13204536.75 3.839000e+03 2020 48626 7.312746e+09 73.3057588 14.13 HURRICANE LAURA Hurricane 6
4559 22127 2020-08-28 2 2 2 2.709224e+06 2709224.08 1.168000e+03 2020 13718 2.335246e+09 22.1444480 37.84 HURRICANE LAURA Hurricane 6
4547 26051 2020-07-09 1 1 1 3.552391e+04 35523.91 8.000000e+03 2020 25371 6.556040e+09 15.1447661 52.45 SEVERE STORMS AND FLOODING Dam/Levee Break 5
4547 26111 2020-07-09 1 1 1 3.983990e+03 3983.99 2.240000e+02 2020 83456 1.828456e+10 64.9061406 94.05 SEVERE STORMS AND FLOODING Dam/Levee Break 5
4547 26145 2020-07-09 2 2 2 1.130423e+05 113042.31 1.027300e+04 2020 190067 3.667700e+10 79.0327712 91.63 SEVERE STORMS AND FLOODING Dam/Levee Break 5
4478 28011 2020-03-12 1 1 1 5.523330e+03 5523.33 5.700000e+01 2020 30953 8.264811e+09 74.5147948 31.09 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4536 28031 2020-04-16 1 1 1 4.324141e+06 4324140.81 9.209000e+03 2020 18330 2.645445e+09 62.5198855 12.73 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4478 28033 2020-03-12 9 1 1 3.221308e+07 10737694.08 8.400000e+04 2020 185280 3.055907e+10 90.8367801 58.85 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4576 28035 2020-12-31 1 1 1 1.132038e+04 11320.38 3.000000e+01 2020 78050 1.342654e+10 86.5415208 59.10 HURRICANE ZETA Hurricane 4
4576 28039 2020-12-31 2 2 2 8.130316e+05 813031.57 4.674000e+02 2020 24246 3.603370e+09 87.0505886 21.13 HURRICANE ZETA Hurricane 4
4576 28045 2020-12-31 4 4 4 5.240651e+06 5240651.43 1.685384e+05 2020 46025 8.381827e+09 88.0687241 60.31 HURRICANE ZETA Hurricane 4
4576 28047 2020-12-31 6 6 6 2.185101e+07 21851008.92 3.431663e+05 2020 208275 3.732934e+10 97.2001273 67.41 HURRICANE ZETA Hurricane 4
4536 28049 2020-04-16 3 3 1 2.524624e+06 2524623.54 3.000000e+03 2020 227510 3.931969e+10 92.5548839 77.37 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4538 28049 2020-04-23 1 1 1 9.462838e+04 94628.38 1.104610e+03 2020 227510 3.931969e+10 92.5548839 77.37 SEVERE STORMS, FLOODING, AND MUDSLIDES Severe Storm 4
4576 28059 2020-12-31 2 2 2 7.319181e+06 7319180.97 5.523345e+04 2020 143149 2.306976e+10 95.9910913 75.88 HURRICANE ZETA Hurricane 4
4536 28061 2020-04-16 1 1 1 1.721371e+06 1721371.35 1.481800e+04 2020 16343 3.036074e+09 48.7750557 21.01 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4536 28065 2020-04-16 1 1 1 3.807595e+06 3807595.45 2.812100e+04 2020 11298 1.934606e+09 29.9395482 19.03 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4536 28067 2020-04-16 2 2 1 3.779986e+06 3779986.23 5.484920e+04 2020 67168 1.431544e+10 87.1460388 34.91 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4551 28067 2020-07-09 1 1 1 8.849760e+05 884975.98 2.179000e+03 2020 67168 1.431544e+10 87.1460388 34.91 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4536 28077 2020-04-16 1 1 1 5.800084e+05 580008.37 8.120000e+01 2020 12013 2.409621e+09 46.2933503 5.70 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4551 28077 2020-07-09 1 1 1 1.262454e+06 1262454.27 4.060000e+01 2020 12013 2.409621e+09 46.2933503 5.70 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4551 28113 2020-07-09 1 1 1 1.438483e+06 1438482.89 2.400000e+02 2020 40285 7.208143e+09 77.2192173 23.81 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4576 28131 2020-12-31 1 1 1 1.625053e+06 1625052.75 1.302000e+02 2020 18312 2.965992e+09 82.5326122 27.66 HURRICANE ZETA Hurricane 4
4478 28135 2020-03-12 1 1 1 8.100000e+04 33000.00 2.194000e+04 2020 12658 1.655110e+09 45.2115813 9.87 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4536 28147 2020-04-16 1 1 1 9.336377e+05 933637.73 1.421300e+03 2020 13882 2.760510e+09 48.9341394 9.90 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4552 29143 2020-07-09 1 1 1 6.512325e+04 65123.25 9.000000e+01 2020 16354 3.863169e+09 82.8825962 28.36 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 7
4574 34003 2020-12-11 1 1 1 1.672281e+05 167228.12 1.200000e+02 2020 955459 1.836780e+11 98.6955138 62.64 TROPICAL STORM ISAIAS Hurricane 2
4567 36059 2020-10-02 2 2 2 4.931242e+05 493124.20 1.357000e+03 2020 1395584 2.703602e+11 96.6592428 95.00 TROPICAL STORM ISAIAS Hurricane 2
4568 37015 2020-10-14 1 1 1 5.983166e+04 59831.66 6.000000e+01 2020 17933 4.394099e+09 82.4371619 15.69 HURRICANE ISAIAS Hurricane 4
4568 37019 2020-10-14 8 8 4 2.274001e+06 2274000.90 5.887770e+04 2020 136245 2.994477e+10 97.0410436 64.93 HURRICANE ISAIAS Hurricane 4
4568 37129 2020-10-14 2 2 2 4.699046e+06 4699046.36 6.891000e+02 2020 225344 5.126031e+10 98.5046134 82.27 HURRICANE ISAIAS Hurricane 4
4575 40051 2020-12-21 1 1 1 1.050575e+05 105057.50 7.200000e+03 2020 54565 8.711522e+09 78.0782692 49.01 SEVERE WINTER STORM Severe Ice Storm 6
4562 41039 2020-09-15 2 2 2 1.213909e+04 12139.09 3.700000e+01 2020 382865 8.188156e+10 96.7865097 63.84 WILDFIRES AND STRAIGHT-LINE WINDS Fire 10
4562 41047 2020-09-15 3 3 3 8.992413e+06 8992413.15 6.880040e+04 2020 344064 6.280993e+10 96.7546930 50.06 WILDFIRES AND STRAIGHT-LINE WINDS Fire 10
4542 45073 2020-05-01 1 1 1 4.369333e+05 436933.33 8.550000e+05 2020 78560 1.733914e+10 65.8924594 40.04 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Severe Storm 4
4542 45077 2020-05-01 1 1 1 2.228122e+04 22281.22 2.000000e+00 2020 131341 2.464922e+10 59.0836780 47.17 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Severe Storm 4
4542 45079 2020-05-01 1 1 1 5.182857e+06 5182856.75 1.740600e+04 2020 415644 8.168495e+10 93.3503023 74.19 SEVERE STORMS, TORNADOES, AND STRAIGHT-LINE WINDS Severe Storm 4
4476 47005 2020-03-05 1 1 1 7.978907e+04 79789.07 5.150000e+02 2020 15849 2.410436e+09 37.0346802 12.57 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4541 47011 2020-04-24 1 1 1 1.293443e+06 1293442.96 5.083000e+03 2020 108482 1.789671e+10 77.4101177 49.14 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4476 47037 2020-03-05 4 4 4 3.338607e+06 3338606.98 5.377850e+04 2020 715485 1.402987e+11 96.5001591 63.08 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4550 47037 2020-07-09 1 1 1 8.015124e+05 801512.44 2.500000e+02 2020 715485 1.402987e+11 96.5001591 63.08 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4541 47065 2020-04-24 3 3 3 1.360949e+07 13603360.40 3.447911e+04 2020 365901 6.771230e+10 92.3958002 76.93 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Severe Storm 4
4476 47141 2020-03-05 1 1 1 6.051809e+05 605180.94 2.792500e+04 2020 79809 1.142029e+10 67.1333121 46.75 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4476 47149 2020-03-05 1 1 1 7.839498e+05 783949.84 2.815940e+03 2020 341253 6.433455e+10 88.2278078 70.53 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4476 47189 2020-03-05 2 2 2 2.390411e+06 2390410.80 1.349610e+05 2020 147693 2.799064e+10 79.7009227 66.07 SEVERE STORMS, TORNADOES, STRAIGHT-LINE WINDS, AND FLOODING Tornado 4
4572 48245 2020-12-09 1 1 1 2.058362e+05 205836.22 1.450000e+03 2020 256386 3.854901e+10 97.7410118 68.01 HURRICANE LAURA Hurricane 6
4572 48351 2020-12-09 1 1 1 3.127118e+05 312711.84 3.560000e+02 2020 12151 2.050022e+09 47.8205536 3.72 HURRICANE LAURA Hurricane 6
4572 48361 2020-12-09 1 1 1 1.385839e+07 13858386.42 7.337196e+04 2020 84645 1.477127e+10 96.5637926 63.75 HURRICANE LAURA Hurricane 6
4572 48453 2020-12-09 2 2 2 2.896741e+07 28967410.41 2.809086e+05 2020 1285769 1.895386e+11 96.8819599 56.75 HURRICANE LAURA Hurricane 6
4539 53033 2020-04-23 1 1 1 1.313171e+05 131317.08 1.866200e+02 2020 2268178 4.701211e+11 99.6500159 78.36 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4539 53067 2020-04-23 1 1 1 2.571660e+04 25716.60 1.400000e+04 2020 294398 5.744299e+10 96.2138085 71.90 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4473 72059 2020-01-16 1 1 1 4.936124e+05 493612.44 6.188000e+03 2020 17690 1.798984e+09 NA NA EARTHQUAKES Earthquake 2
4473 72113 2020-01-16 3 3 3 8.767199e+04 87671.99 4.296124e+05 2020 137316 2.102578e+10 NA NA EARTHQUAKES Earthquake 2
4596 01015 2021-04-26 1 1 1 3.238120e+06 3238120.48 1.215400e+03 2021 116250 2.269150e+10 84.3779828 46.72 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4596 01105 2021-04-26 1 1 1 7.302500e+05 730250.00 2.660000e+03 2021 8480 1.455191e+09 13.7130130 10.88 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4596 01117 2021-04-26 1 1 1 1.805876e+05 180587.60 1.500000e+02 2021 222782 4.221177e+10 87.4005727 74.09 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4585 02100 2021-02-17 1 1 1 2.884985e+05 288498.54 1.650802e+01 2021 2080 8.783506e+08 3.7225581 25.02 SEVERE STORM, FLOODING, LANDSLIDES, AND MUDSLIDES Mud/Landslide 10
4610 06063 2021-08-24 1 1 1 4.300000e+03 4300.00 1.657000e+01 2021 19746 8.405356e+09 78.9691378 62.95 WILDFIRES Fire 9
4634 08013 2021-12-31 3 3 3 1.156198e+06 1156197.82 1.142980e+05 2021 330652 6.223313e+10 89.5004773 71.01 WILDFIRES AND STRAIGHT-LINE WINDS Fire 8
4627 10003 2021-10-24 2 2 2 2.598896e+05 259889.60 6.838600e+02 2021 570089 1.221791e+11 90.7731467 83.26 REMNANTS OF HURRICANE IDA Hurricane 3
3560 12086 2021-06-25 2 2 1 1.072216e+07 10722161.01 2.600000e+04 2021 2698679 3.195744e+11 99.8090996 37.11 SURFSIDE BUILDING COLLAPSE Other 4
4600 13077 2021-05-05 3 3 3 4.371243e+06 4371242.55 7.118797e+05 2021 146099 2.776655e+10 67.6423799 59.99 SEVERE STORMS AND TORNADOES Severe Storm 4
4589 16055 2021-03-04 1 1 1 3.438445e+05 343844.52 1.680000e+01 2021 171251 3.499817e+10 61.3108495 54.14 STRAIGHT-LINE WINDS Severe Storm 10
4595 21007 2021-04-23 1 1 1 2.700000e+04 27000.00 5.220000e+02 2021 7718 1.561990e+09 44.6070633 42.23 SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4630 21009 2021-12-12 1 1 1 2.553630e+03 2553.63 1.440000e+02 2021 44465 8.877867e+09 66.4333439 47.20 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21033 2021-12-12 2 2 2 6.565992e+05 656599.23 4.155400e+04 2021 12649 2.503478e+09 53.7384664 32.94 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21047 2021-12-12 3 3 3 1.378318e+05 137831.79 3.264940e+03 2021 72692 1.162218e+10 84.3143493 51.56 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4595 21065 2021-04-23 2 2 2 7.166988e+04 71669.88 3.002000e+03 2021 14163 2.046989e+09 25.3897550 10.98 SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4630 21067 2021-12-12 65 2 2 2.116366e+07 2287470.95 5.827680e+03 2021 322301 5.665312e+10 88.2914413 72.09 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21073 2021-12-12 9 9 8 4.508859e+06 4508859.06 8.094045e+04 2021 51521 1.006136e+10 62.8062361 71.55 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21075 2021-12-12 2 2 2 4.228770e+05 422877.01 2.408400e+03 2021 6515 1.438054e+09 58.3200764 20.50 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21083 2021-12-12 3 3 3 1.526278e+04 3626.00 5.140000e+02 2021 36623 8.112734e+09 83.7734648 32.56 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21099 2021-12-12 2 2 2 6.256349e+04 62563.49 1.695000e+03 2021 19277 3.607581e+09 41.0435889 36.60 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21107 2021-12-12 7 4 4 8.368929e+06 8289847.64 2.587903e+05 2021 45395 9.084016e+09 75.4056634 58.31 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4595 21115 2021-04-23 1 1 1 2.840255e+04 28402.55 2.004440e+05 2021 22621 3.501458e+09 46.8978683 13.11 SEVERE, STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4630 21141 2021-12-12 1 1 1 6.720949e+04 67209.49 1.817030e+03 2021 27382 4.856890e+09 55.4247534 39.66 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21143 2021-12-12 2 2 2 2.288122e+06 2288121.96 5.186950e+04 2021 8663 1.923462e+09 32.0394528 19.41 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21155 2021-12-12 2 2 2 4.249877e+04 42498.77 3.304000e+02 2021 19521 4.044451e+09 33.3439389 61.90 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21157 2021-12-12 3 3 3 6.375770e+06 6375770.17 1.227147e+05 2021 31629 6.869117e+09 71.5876551 62.32 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21177 2021-12-12 1 1 1 1.314805e+06 1314805.15 2.451000e+04 2021 30928 5.279739e+09 50.7476933 36.44 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21183 2021-12-12 4 4 4 2.166854e+05 200593.15 6.134830e+04 2021 23745 5.697402e+09 52.4657970 50.32 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4630 21227 2021-12-12 6 6 6 4.548012e+06 4548012.41 7.190880e+04 2021 134482 2.463868e+10 83.0098632 64.99 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, AND TORNADOES Tornado 4
4606 22005 2021-06-02 1 1 1 5.904640e+03 5904.64 2.930000e+02 2021 126426 3.019167e+10 96.2774419 88.45 SEVERE STORMS, TORNADOES, AND FLOODING Flood 6
4611 22005 2021-08-29 15 12 12 1.647677e+07 14289528.63 3.485034e+04 2021 126426 3.019167e+10 96.2774419 88.45 HURRICANE IDA Hurricane 6
4611 22007 2021-08-29 3 3 3 4.065902e+05 406590.23 8.911550e+03 2021 21017 3.291188e+09 86.3506204 48.89 HURRICANE IDA Hurricane 6
4606 22019 2021-06-02 2 2 2 1.104108e+06 1104107.98 4.183475e+04 2021 216652 4.227924e+10 96.9137766 32.40 SEVERE STORMS, TORNADOES, AND FLOODING Flood 6
4577 22033 2021-01-12 1 1 1 3.017367e+06 3017366.97 1.708700e+04 2021 456512 1.120657e+11 98.8864143 60.09 HURRICANE ZETA Hurricane 6
4606 22033 2021-06-02 1 1 1 6.457675e+05 645767.50 2.963400e+04 2021 456512 1.120657e+11 98.8864143 60.09 SEVERE STORMS, TORNADOES, AND FLOODING Flood 6
4611 22033 2021-08-29 9 9 9 1.156044e+08 115604437.67 7.387389e+05 2021 456512 1.120657e+11 98.8864143 60.09 HURRICANE IDA Hurricane 6
4577 22051 2021-01-12 3 3 3 5.835583e+06 5835582.78 1.478800e+04 2021 440590 6.529661e+10 98.1546293 96.05 HURRICANE ZETA Hurricane 6
4611 22051 2021-08-29 89 20 20 2.649678e+08 99902962.58 1.250207e+06 2021 440590 6.529661e+10 98.1546293 96.05 HURRICANE IDA Hurricane 6
4577 22057 2021-01-12 1 1 1 1.131015e+06 1131015.01 2.927500e+04 2021 97393 1.283919e+10 94.4002545 91.34 HURRICANE ZETA Hurricane 6
4611 22057 2021-08-29 135 12 12 1.004245e+08 58715475.40 1.685344e+06 2021 97393 1.283919e+10 94.4002545 91.34 HURRICANE IDA Hurricane 6
4611 22063 2021-08-29 4 4 4 2.107511e+07 21075105.63 1.950200e+04 2021 142163 2.617953e+10 96.8501432 57.48 HURRICANE IDA Hurricane 6
4577 22071 2021-01-12 2 2 2 3.092847e+06 3092847.22 1.125400e+04 2021 383606 5.814887e+10 96.9774101 99.40 HURRICANE ZETA Hurricane 6
4611 22071 2021-08-29 13 13 13 1.316914e+07 13169142.82 1.539474e+05 2021 383606 5.814887e+10 96.9774101 99.40 HURRICANE IDA Hurricane 6
4577 22075 2021-01-12 1 1 1 6.771487e+05 677148.67 1.914000e+03 2021 23448 4.870262e+09 82.6916958 94.33 HURRICANE ZETA Hurricane 6
4611 22075 2021-08-29 4 4 4 1.631102e+07 16311021.01 5.243400e+04 2021 23448 4.870262e+09 82.6916958 94.33 HURRICANE IDA Hurricane 6
4577 22087 2021-01-12 2 2 2 8.014001e+05 801400.14 9.757830e+03 2021 43709 6.549944e+09 86.6051543 91.79 HURRICANE ZETA Hurricane 6
4611 22087 2021-08-29 6 6 6 2.141927e+06 2141926.92 2.646608e+04 2021 43709 6.549944e+09 86.6051543 91.79 HURRICANE IDA Hurricane 6
4577 22089 2021-01-12 1 1 1 3.237694e+05 323769.37 3.958000e+02 2021 52479 8.228203e+09 90.3277124 99.97 HURRICANE ZETA Hurricane 6
4611 22089 2021-08-29 23 12 12 2.490244e+07 24780398.10 5.848307e+05 2021 52479 8.228203e+09 90.3277124 99.97 HURRICANE IDA Hurricane 6
4611 22091 2021-08-29 1 1 1 3.508953e+06 3508953.44 3.997500e+02 2021 10911 1.816039e+09 48.2659879 24.25 HURRICANE IDA Hurricane 6
4611 22093 2021-08-29 9 6 6 7.269766e+06 4535671.86 3.920930e+04 2021 20169 4.201279e+09 76.8692332 96.82 HURRICANE IDA Hurricane 6
4611 22095 2021-08-29 15 7 7 1.928605e+08 74935394.21 2.070212e+06 2021 42466 8.175506e+09 86.5733376 99.90 HURRICANE IDA Hurricane 6
4611 22101 2021-08-29 2 2 2 3.020996e+05 302099.61 4.000000e+00 2021 49313 1.172348e+10 94.7184219 78.13 HURRICANE IDA Hurricane 6
4611 22103 2021-08-29 10 10 10 5.641922e+07 56419218.21 1.991214e+05 2021 263870 4.368477e+10 97.8046452 87.91 HURRICANE IDA Hurricane 6
4611 22105 2021-08-29 2 2 2 5.219528e+07 52195275.17 9.608625e+04 2021 132858 2.072858e+10 96.1501750 57.73 HURRICANE IDA Hurricane 6
4577 22109 2021-01-12 1 1 1 1.438236e+05 143823.58 1.600000e+02 2021 109484 2.195670e+10 96.3728921 94.75 HURRICANE ZETA Hurricane 6
4611 22109 2021-08-29 7 7 7 1.506119e+07 7449699.92 2.607010e+05 2021 109484 2.195670e+10 96.3728921 94.75 HURRICANE IDA Hurricane 6
4611 22117 2021-08-29 2 2 2 2.580516e+05 258051.58 8.925000e+02 2021 45382 7.554000e+09 89.3732103 25.05 HURRICANE IDA Hurricane 6
4607 26163 2021-07-15 8 8 8 1.203159e+07 12031592.63 3.671430e+04 2021 1792549 3.174907e+11 96.6910595 56.56 SEVERE STORMS, FLOODING, AND TORNADOES Severe Storm 5
4598 28001 2021-05-04 1 1 1 7.753157e+05 775315.71 1.632000e+03 2021 29474 4.966114e+09 54.3748011 26.58 SEVERE WINTER STORMS Severe Ice Storm 4
4626 28047 2021-10-23 1 1 1 5.200653e+05 520065.35 2.913900e+04 2021 208275 3.732934e+10 97.2001273 67.41 HURRICANE IDA Hurricane 4
4614 34003 2021-09-05 34 26 26 4.099809e+06 3208893.03 2.447749e+05 2021 955459 1.836780e+11 98.6955138 62.64 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34013 2021-09-05 9 9 9 3.761962e+06 3761961.75 4.349900e+04 2021 863448 1.279945e+11 92.7457843 31.29 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34015 2021-09-05 3 3 3 4.259833e+05 425983.30 6.922440e+03 2021 302128 6.000103e+10 84.7279669 87.21 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34017 2021-09-05 8 8 7 1.538086e+06 1538086.36 2.920270e+04 2021 723485 8.143320e+10 95.3865733 38.16 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34019 2021-09-05 10 10 10 6.150691e+05 615069.08 1.364898e+04 2021 128867 3.828055e+10 79.3827553 94.46 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34021 2021-09-05 2 2 2 2.414260e+05 241425.98 1.634000e+03 2021 386483 8.246538e+10 93.0321349 73.65 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34023 2021-09-05 9 9 9 1.488941e+06 1488940.52 2.533134e+04 2021 862614 1.753605e+11 95.8638244 59.20 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34027 2021-09-05 1 1 1 1.852445e+05 185244.52 4.800000e+02 2021 508868 1.186671e+11 90.7095132 92.01 REMNANTS OF HURRICANE IDA Hurricane 2
4597 34029 2021-04-28 2 2 2 2.492861e+04 24928.61 1.150000e+02 2021 636993 1.058262e+11 97.2319440 89.27 SEVERE WINTER STORM AND SNOWSTORM Snowstorm 2
4614 34031 2021-09-05 14 14 10 1.659818e+06 1659818.14 1.883069e+05 2021 523958 7.427218e+10 89.6595609 41.88 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34035 2021-09-05 21 21 20 7.212616e+06 7212616.30 1.544265e+05 2021 345266 8.593257e+10 93.4139357 88.67 REMNANTS OF HURRICANE IDA Hurricane 2
4614 34039 2021-09-05 17 17 16 3.877424e+06 3877424.30 1.535021e+06 2021 575179 9.266494e+10 92.4276169 38.29 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36005 2021-09-05 1 1 1 3.832720e+03 3832.72 4.000000e+01 2021 1471631 1.365967e+11 96.3092587 6.46 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36027 2021-09-05 1 1 1 5.614820e+03 5614.82 2.710300e+05 2021 295788 6.225758e+10 76.9328667 78.39 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36047 2021-09-05 1 1 1 1.131723e+04 11317.23 2.056400e+04 2021 2735309 3.306987e+11 98.1228126 9.45 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36059 2021-09-05 4 4 4 1.137343e+05 113734.29 7.278000e+02 2021 1395584 2.703602e+11 96.6592428 95.00 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36061 2021-09-05 1 1 1 3.063000e+04 30630.00 1.000000e+02 2021 1693650 2.601753e+11 96.1819917 49.97 REMNANTS OF HURRICANE IDA Hurricane 2
4625 36067 2021-10-08 1 1 1 9.111608e+04 91116.08 1.295800e+04 2021 476419 9.074455e+10 76.6146993 90.29 REMNANTS OF TROPICAL STORM FRED Hurricane 2
4615 36071 2021-09-05 1 1 1 8.258620e+03 8258.62 6.180000e+03 2021 401096 7.171433e+10 85.2052179 70.97 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36079 2021-09-05 1 1 1 1.198772e+04 11987.72 1.468000e+01 2021 97640 2.033413e+10 50.8431435 87.52 REMNANTS OF HURRICANE IDA Hurricane 2
4625 36101 2021-10-08 2 2 2 1.437029e+05 143702.90 5.687660e+05 2021 93544 1.955800e+10 64.4288896 70.50 REMNANTS OF TROPICAL STORM FRED Hurricane 2
4615 36103 2021-09-05 1 1 1 1.395300e+04 13953.00 1.940000e+03 2021 1524969 3.491028e+11 97.1364938 94.81 REMNANTS OF HURRICANE IDA Hurricane 2
4615 36119 2021-09-05 17 17 17 4.703006e+06 4703005.94 8.306886e+04 2021 1002867 1.800880e+11 94.3048043 77.72 REMNANTS OF HURRICANE IDA Hurricane 2
4617 37021 2021-09-08 1 1 1 3.450863e+05 345086.33 1.230000e+03 2021 269305 4.863094e+10 81.4826599 59.61 REMNANTS OF TROPICAL STORM FRED Hurricane 4
4617 37087 2021-09-08 1 1 1 3.082492e+04 30824.92 2.274000e+03 2021 62051 1.040115e+10 61.8835507 50.80 REMNANTS OF TROPICAL STORM FRED Hurricane 4
4588 37183 2021-03-03 9 1 1 6.166113e+05 205537.11 1.170600e+04 2021 1128357 2.152861e+11 93.6366529 72.02 TROPICAL STORM ETA Severe Storm 4
4618 42017 2021-09-10 1 1 1 3.178184e+04 31781.84 1.500000e+02 2021 646216 1.587404e+11 92.2367165 80.33 REMNANTS OF HURRICANE IDA Hurricane 3
4618 42029 2021-09-10 1 1 1 4.787584e+04 47875.84 0.000000e+00 2021 534152 1.458534e+11 91.9821826 86.00 REMNANTS OF HURRICANE IDA Hurricane 3
4618 42043 2021-09-10 3 3 3 2.747946e+05 274794.56 5.555840e+04 2021 286115 6.227298e+10 89.3095768 97.49 REMNANTS OF HURRICANE IDA Hurricane 3
4618 42091 2021-09-10 4 4 4 6.569060e+06 6569060.33 1.509200e+04 2021 856020 2.069151e+11 94.0820872 94.08 REMNANTS OF HURRICANE IDA Hurricane 3
4618 42101 2021-09-10 1 1 1 1.099364e+05 108533.89 5.135800e+02 2021 1602305 2.598294e+11 98.1864461 42.84 REMNANTS OF HURRICANE IDA Hurricane 3
4618 42133 2021-09-10 1 1 1 1.084047e+04 10840.47 2.000000e+00 2021 456310 8.409368e+10 83.9961820 90.48 REMNANTS OF HURRICANE IDA Hurricane 3
4601 47037 2021-05-08 1 1 1 1.466241e+05 146624.09 2.916000e+03 2021 715485 1.402987e+11 96.5001591 63.08 SEVERE STORMS, TORNADOES, AND FLOODING Tornado 4
4609 47037 2021-08-23 1 1 1 2.432929e+05 243292.87 1.593000e+04 2021 715485 1.402987e+11 96.5001591 63.08 SEVERE STORM AND FLOODING Flood 4
4609 47081 2021-08-23 1 1 1 4.308486e+04 43084.86 1.218100e+02 2021 24872 4.530279e+09 47.5660197 14.51 SEVERE STORM AND FLOODING Flood 4
4609 47085 2021-08-23 12 4 4 5.117235e+06 4202070.67 2.209380e+05 2021 18964 3.290526e+09 43.5252943 51.88 SEVERE STORM AND FLOODING Flood 4
4601 47187 2021-05-08 1 1 1 9.670780e+03 9670.78 1.680000e+02 2021 247523 5.469015e+10 77.9828190 86.19 SEVERE STORMS, TORNADOES, AND FLOODING Tornado 4
4601 47189 2021-05-08 1 1 1 6.529950e+03 6529.95 4.259168e+05 2021 147693 2.799064e+10 79.7009227 66.07 SEVERE STORMS, TORNADOES, AND FLOODING Tornado 4
4586 48167 2021-02-19 2 2 2 8.389754e+04 83897.54 3.464100e+03 2021 350477 5.674698e+10 99.5227490 90.36 SEVERE WINTER STORMS Severe Ice Storm 6
4578 49011 2021-01-12 2 2 2 2.270630e+05 227062.95 6.985800e+03 2021 362649 4.792347e+10 93.7957366 98.31 STRAIGHT-LINE WINDS Severe Storm 8
4628 51027 2021-10-26 1 1 1 2.926114e+05 292611.44 1.100000e+01 2021 20340 2.256744e+09 46.8024181 3.63 FLOODING, LANDSLIDES, AND MUDSLIDES Flood 3
4628 51760 2021-10-26 1 1 1 3.528272e+05 352827.20 8.500000e+01 2021 226269 4.353533e+10 73.2421254 54.84 FLOODING, LANDSLIDES, AND MUDSLIDES Flood 3
4584 53021 2021-02-04 1 1 1 1.142333e+04 11423.33 5.110000e+03 2021 96653 1.402875e+10 68.4696150 28.61 WILDFIRES AND STRAIGHT-LINE WINDS Fire 10
4593 53047 2021-04-08 1 1 1 3.682250e+03 3682.25 8.000000e+00 2021 42016 9.411749e+09 85.0779510 19.70 SEVERE WINTER STORM, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 10
4584 53053 2021-02-04 1 1 1 4.567225e+06 4567224.89 1.277000e+03 2021 920483 1.607052e+11 98.7273306 70.56 WILDFIRES AND STRAIGHT-LINE WINDS Fire 10
4584 53075 2021-02-04 2 2 2 8.158387e+04 81583.87 2.593900e+04 2021 47922 9.223151e+09 23.8307350 43.48 WILDFIRES AND STRAIGHT-LINE WINDS Fire 10
4672 02180 2022-09-23 1 1 1 5.482220e+03 5482.22 5.000000e+01 2022 10031 1.993288e+09 3.4043907 25.18 SEVERE STORM, FLOODING, AND LANDSLIDES Severe Storm 10
4673 12009 2022-09-29 2 2 2 2.011795e+05 201179.46 2.137500e+02 2022 606067 1.055946e+11 99.3636653 59.83 HURRICANE IAN Hurricane 4
4673 12015 2022-09-29 6 6 6 4.226326e+07 42263262.65 5.860211e+05 2022 186734 3.146261e+10 96.5956093 11.94 HURRICANE IAN Hurricane 4
4673 12021 2022-09-29 7 4 4 1.071419e+08 53598049.05 1.068079e+06 2022 375443 8.254240e+10 98.8545975 20.15 HURRICANE IAN Hurricane 4
4673 12027 2022-09-29 3 3 3 1.591684e+07 15916838.67 5.358010e+04 2022 33898 5.358888e+09 90.4231626 1.11 HURRICANE IAN Hurricane 4
4673 12049 2022-09-29 1 1 1 4.906879e+06 4906879.32 9.000000e+03 2022 25302 3.815820e+09 80.2736239 3.53 HURRICANE IAN Hurricane 4
4673 12051 2022-09-29 1 1 1 2.348518e+05 234851.81 1.280000e+02 2022 39371 6.080710e+09 91.1549475 0.89 HURRICANE IAN Hurricane 4
4673 12055 2022-09-29 3 3 3 8.649117e+06 8649116.66 1.072570e+04 2022 101136 1.753236e+10 90.2958956 4.81 HURRICANE IAN Hurricane 4
4673 12069 2022-09-29 1 1 1 2.741030e+05 274103.02 1.590000e+02 2022 383042 5.896930e+10 95.2274897 48.09 HURRICANE IAN Hurricane 4
4673 12071 2022-09-29 21 18 18 1.530937e+08 153093719.52 1.775402e+06 2022 759922 1.233084e+11 99.4909322 9.17 HURRICANE IAN Hurricane 4
4673 12073 2022-09-29 33 18 18 3.930296e+08 250301311.25 6.847536e+06 2022 292157 4.688315e+10 94.5593382 74.76 HURRICANE IAN Hurricane 4
4673 12081 2022-09-29 4 4 4 1.391334e+07 13913335.48 6.184630e+03 2022 399485 6.672028e+10 98.4409800 23.90 HURRICANE IAN Hurricane 4
4673 12087 2022-09-29 2 2 2 1.693228e+06 1693227.63 1.323848e+04 2022 82390 1.808080e+10 95.9274578 27.88 HURRICANE IAN Hurricane 4
4673 12093 2022-09-29 2 2 2 4.217873e+06 4217873.08 5.363350e+03 2022 39455 6.060952e+09 87.5914731 2.42 HURRICANE IAN Hurricane 4
4673 12095 2022-09-29 3 3 3 2.876846e+06 2876846.22 1.024580e+04 2022 1428790 2.324704e+11 98.5682469 43.92 HURRICANE IAN Hurricane 4
4673 12097 2022-09-29 3 3 3 7.045912e+05 704591.23 1.132150e+04 2022 387795 5.045786e+10 95.1320395 35.74 HURRICANE IAN Hurricane 4
4680 12099 2022-12-13 1 1 1 1.125666e+05 112566.65 4.880000e+01 2022 1489461 2.385678e+11 99.7136494 23.65 HURRICANE NICOLE Hurricane 4
4673 12103 2022-09-29 2 2 2 1.324950e+05 132495.00 3.611600e+02 2022 958822 1.452981e+11 99.2045816 12.00 HURRICANE IAN Hurricane 4
4673 12109 2022-09-29 2 2 2 7.317271e+05 731727.09 3.242650e+03 2022 273175 5.135085e+10 94.1457206 81.99 HURRICANE IAN Hurricane 4
4680 12111 2022-12-13 1 1 1 4.950000e+03 4950.00 9.000000e+00 2022 328876 4.431051e+10 98.3137130 46.21 HURRICANE NICOLE Hurricane 4
4673 12115 2022-09-29 9 9 8 2.624248e+07 26242484.88 9.647222e+04 2022 433908 8.064207e+10 98.4091632 9.23 HURRICANE IAN Hurricane 4
4673 12117 2022-09-29 6 6 6 9.515614e+06 9515614.45 8.698750e+03 2022 470586 7.253923e+10 95.6411072 64.58 HURRICANE IAN Hurricane 4
4673 12119 2022-09-29 1 1 1 6.906994e+04 69069.94 1.000000e+01 2022 129698 2.082162e+10 88.9277760 38.67 HURRICANE IAN Hurricane 4
4673 12127 2022-09-29 15 15 15 1.633062e+07 16330624.32 2.140567e+05 2022 551829 8.247022e+10 97.5182946 45.64 HURRICANE IAN Hurricane 4
4642 19067 2022-02-23 1 1 1 1.589096e+04 0.00 2.623704e+02 2022 15615 3.686895e+09 42.9525931 86.76 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 7
4640 20053 2022-02-17 1 1 1 1.400319e+04 14003.19 1.120000e+02 2022 6367 2.468475e+09 40.0254534 59.36 SEVERE STORMS AND STRAIGHT LINE WINDS Severe Storm 7
4640 20169 2022-02-17 1 1 1 3.983770e+03 3983.77 1.900000e+01 2022 54303 1.186593e+10 77.8873688 86.38 SEVERE STORMS AND STRAIGHT LINE WINDS Severe Storm 7
4663 21025 2022-07-29 8 5 5 2.769438e+05 183864.59 9.392259e+04 2022 13610 1.933137e+09 29.8759147 2.77 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4663 21073 2022-07-29 5 5 5 5.998917e+07 59989172.12 1.014424e+06 2022 51521 1.006136e+10 62.8062361 71.55 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4663 21133 2022-07-29 3 3 3 2.431930e+05 243192.99 1.498740e+04 2022 21438 3.854601e+09 29.8440980 5.25 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4663 21159 2022-07-29 1 1 1 1.793846e+04 17938.46 9.372000e+01 2022 11285 1.444151e+09 33.6302895 1.65 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 4
4658 27001 2022-07-08 1 1 1 1.497580e+04 14975.80 5.000000e+02 2022 15674 5.084602e+09 10.6904232 95.96 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4666 27007 2022-08-09 1 1 1 1.079546e+04 10795.46 5.000000e+01 2022 46103 1.173116e+10 36.3028953 88.96 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4666 27041 2022-08-09 1 1 1 9.137020e+03 9137.02 1.503800e+02 2022 38992 1.160771e+10 31.9121858 97.96 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4659 27071 2022-07-13 1 1 1 8.733919e+05 873391.90 1.350000e+02 2022 12059 2.782644e+09 0.6681514 85.65 SEVERE STORMS, STRAIGHT-LINE WINDS, AND FLOODING Flood 5
4658 27073 2022-07-08 1 1 1 2.950788e+04 29507.88 5.400000e+02 2022 6711 2.455724e+09 14.7947821 86.16 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4658 27123 2022-07-08 1 1 1 6.467121e+04 64671.21 1.200000e+02 2022 552246 1.001147e+11 92.1094496 95.07 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4658 27149 2022-07-08 1 1 1 3.313251e+04 33132.51 3.000000e+00 2022 9670 3.506548e+09 14.6675151 93.92 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4666 27159 2022-08-09 1 1 1 5.376360e+03 5376.36 1.000000e+03 2022 14054 3.447234e+09 16.1947184 85.81 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 5
4665 29183 2022-08-08 3 3 3 1.106059e+05 110605.87 1.571400e+04 2022 405183 8.092181e+10 93.0003182 96.24 SEVERE STORMS AND FLOODING Flood 7
4665 29189 2022-08-08 1 1 1 3.694460e+03 3694.46 4.000000e+01 2022 1003734 2.351181e+11 98.5364302 77.66 SEVERE STORMS AND FLOODING Flood 7
4665 29510 2022-08-08 1 1 1 9.184803e+04 91848.03 4.000000e+01 2022 301414 6.615276e+10 95.3547566 61.14 SEVERE STORMS AND FLOODING Flood 7
4655 30049 2022-06-16 4 1 1 1.849497e+07 9247486.18 1.306541e+06 2022 70922 1.384361e+10 51.1613108 76.61 SEVERE STORM AND FLOODING Flood 8
4655 30067 2022-06-16 3 3 3 1.112039e+05 111203.85 1.962795e+04 2022 17153 5.181397e+09 23.7352848 76.51 SEVERE STORM AND FLOODING Flood 8
4662 31107 2022-07-27 1 1 1 9.793602e+04 11300.00 1.300000e+02 2022 8383 3.127981e+09 35.8574610 47.71 SEVERE STORMS AND STRAIGHT-LINE WINDS Severe Storm 7
4652 35049 2022-05-05 1 1 1 2.042694e+07 20426936.70 4.000000e+03 2022 154509 3.089753e+10 81.1963093 34.21 WILDFIRES, STRAIGHT-LINE WINDS, FLOODING, MUDFLOWS, AND DEBRIS FLOWS Fire 6
4677 45019 2022-11-21 3 3 3 1.453644e+06 1453644.48 1.643896e+04 2022 407722 8.599560e+10 99.4591155 92.71 HURRICANE IAN Hurricane 4
4677 45043 2022-11-21 3 3 3 8.231594e+04 82315.94 3.525200e+02 2022 63262 1.409163e+10 95.2593064 58.59 HURRICANE IAN Hurricane 4
4677 45051 2022-11-21 1 1 1 1.352706e+05 135270.62 3.200000e+01 2022 348574 6.455071e+10 98.9818645 61.30 HURRICANE IAN Hurricane 4
4677 45079 2022-11-21 2 2 2 9.290531e+05 929053.06 4.222000e+03 2022 415644 8.168495e+10 93.3503023 74.19 HURRICANE IAN Hurricane 4
4656 46009 2022-06-29 1 1 1 4.543667e+04 45436.67 6.225000e+02 2022 6996 2.156272e+09 17.1174038 58.63 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46011 2022-06-29 1 1 1 2.225375e+04 22253.75 1.600000e+02 2022 34375 1.010820e+10 76.2965320 74.00 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46057 2022-06-29 1 1 1 2.860099e+05 286009.86 3.328810e+03 2022 6164 2.428631e+09 33.9484569 79.09 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46065 2022-06-29 1 1 1 1.104682e+05 110468.23 3.773000e+03 2022 17751 3.816304e+09 47.1205854 85.90 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46077 2022-06-29 1 1 1 1.252497e+05 125249.72 6.525000e+02 2022 5183 2.874478e+09 33.7257397 91.57 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46087 2022-06-29 2 2 2 2.326145e+05 232614.46 2.944140e+03 2022 5682 1.196086e+10 69.1059497 88.70 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46099 2022-06-29 2 2 2 2.198004e+05 219800.43 7.542000e+02 2022 196891 3.733547e+10 92.5867006 93.13 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4656 46101 2022-06-29 1 1 1 7.411780e+03 7411.78 5.000000e+01 2022 6336 3.337204e+09 53.2930321 74.35 SEVERE STORM, STRAIGHT-LINE WINDS, TORNADOES, AND FLOODING Severe Storm 8
4637 47037 2022-01-14 3 3 3 1.223647e+06 1223647.28 1.823000e+03 2022 715485 1.402987e+11 96.5001591 63.08 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 4
4637 47043 2022-01-14 1 1 1 2.417185e+05 241718.45 4.200000e+02 2022 54292 8.838771e+09 64.8425072 45.16 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 4
4637 47131 2022-01-14 4 1 1 3.045821e+05 152291.06 1.122222e+04 2022 30777 4.898492e+09 77.7601018 36.76 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 4
4637 47183 2022-01-14 9 1 1 2.955783e+07 9852608.79 2.925000e+05 2022 32891 5.108212e+09 78.4918867 31.19 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 4
4674 51760 2022-09-30 1 1 1 1.720723e+06 1720722.95 6.744000e+03 2022 226269 4.353533e+10 73.2421254 54.84 FLOODING AND MUDSLIDES Severe Storm 3
4650 53021 2022-03-29 1 1 1 8.176734e+04 81767.34 3.600000e+02 2022 96653 1.402875e+10 68.4696150 28.61 SEVERE WINTER STORMS, SNOWSTORMS, STRAIGHT-LINE WINDS, FLOODIN Flood 10
4635 53057 2022-01-05 1 1 1 6.477661e+04 64776.61 2.431746e+04 2022 129360 2.649981e+10 89.1186764 77.02 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4635 53073 2022-01-05 5 2 1 3.715787e+05 311774.71 1.801400e+05 2022 226681 4.568536e+10 90.9322304 79.50 SEVERE STORMS, STRAIGHT-LINE WINDS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 10
4679 54019 2022-11-28 1 1 1 5.311186e+04 53111.86 4.870600e+02 2022 40383 5.823612e+09 24.7534203 26.61 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 3
4671 72005 2022-09-21 1 1 1 9.574480e+03 9574.48 6.000000e+00 2022 54977 9.841042e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72009 2022-09-21 1 1 1 6.721767e+05 672176.66 1.600000e+04 2022 24637 3.015895e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72011 2022-09-21 1 1 1 1.237893e+06 1237893.47 8.295000e+02 2022 25546 3.097504e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72027 2022-09-21 1 1 1 7.468564e+05 746856.39 8.116600e+02 2022 32797 3.642558e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72031 2022-09-21 1 1 1 6.234365e+04 62343.65 4.000000e+02 2022 154696 2.283049e+10 NA NA HURRICANE FIONA Hurricane 2
4671 72059 2022-09-21 1 1 1 8.633778e+05 863377.78 6.711000e+02 2022 17690 1.798984e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72105 2022-09-21 1 1 1 2.860372e+05 286037.25 1.009000e+02 2022 29241 2.934399e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72109 2022-09-21 1 1 1 2.258948e+06 2258948.25 3.930802e+04 2022 15929 2.009534e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72111 2022-09-21 2 2 2 4.559558e+06 4559557.59 2.068581e+04 2022 20320 2.518446e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72117 2022-09-21 1 1 1 1.232206e+05 123220.62 5.532000e+02 2022 15187 2.056385e+09 NA NA HURRICANE FIONA Hurricane 2
4671 72153 2022-09-21 1 1 1 9.287350e+05 928735.00 2.809000e+03 2022 34151 3.045488e+09 NA NA HURRICANE FIONA Hurricane 2
4684 01001 2023-01-15 4 1 1 3.067286e+06 1533642.78 4.256000e+03 2023 58764 9.123274e+09 49.2204900 51.81 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01017 2023-01-15 2 2 2 1.655437e+05 165543.74 4.200000e+01 2023 34738 5.993491e+09 42.3480751 40.13 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01047 2023-01-15 5 5 5 7.667066e+06 7667065.61 9.147565e+04 2023 38341 6.955631e+09 57.8428253 44.21 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01051 2023-01-15 1 1 1 2.624263e+05 262426.34 1.287000e+03 2023 87755 1.251095e+10 57.2701241 57.07 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01063 2023-01-15 2 2 2 4.183933e+05 418393.30 2.392800e+02 2023 7714 1.339905e+09 18.0400891 5.98 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01065 2023-01-15 2 2 2 3.015091e+05 301509.11 1.260400e+03 2023 14753 2.427858e+09 33.1530385 13.40 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01101 2023-01-15 2 2 2 1.423541e+06 1423541.34 3.996000e+03 2023 228847 4.622347e+10 86.2551702 67.92 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01119 2023-01-15 2 2 2 5.275280e+04 52752.80 4.354500e+02 2023 12322 3.236461e+09 51.0658606 7.54 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4684 01123 2023-01-15 1 1 1 4.998020e+04 49980.20 1.200000e+03 2023 41279 8.545817e+09 50.0477251 43.25 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4698 05037 2023-04-02 6 3 3 2.071781e+07 10704864.50 3.360577e+05 2023 16824 3.357621e+09 66.4969774 33.64 SEVERE STORMS AND TORNADOES Severe Storm 6
4698 05119 2023-04-02 1 1 1 3.806886e+05 380688.64 1.059500e+04 2023 398830 7.392333e+10 95.0684060 73.68 SEVERE STORMS AND TORNADOES Severe Storm 6
4683 06085 2023-01-14 1 1 1 1.337007e+05 133700.70 1.500000e+01 2023 1934625 3.815867e+11 99.8409163 68.94 SEVERE WINTER STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 9
4709 12011 2023-04-27 1 1 1 1.540372e+06 1540372.01 4.170200e+04 2023 1940829 2.681728e+11 99.7454661 44.84 SEVERE STORMS, TORNADOES, AND FLOODING Flood 4
4734 12017 2023-08-31 3 3 3 1.434055e+06 1434055.44 8.128043e+04 2023 153476 2.146307e+10 95.8956411 7.13 HURRICANE IDALIA Hurricane 4
4734 12075 2023-08-31 2 2 2 1.062832e+06 1062831.95 4.746850e+04 2023 42750 4.701759e+09 83.2643971 8.40 HURRICANE IDALIA Hurricane 4
4734 12101 2023-08-31 3 3 3 1.103308e+05 110330.80 1.611960e+03 2023 561566 8.980181e+10 99.0454979 13.21 HURRICANE IDALIA Hurricane 4
4734 12103 2023-08-31 3 3 3 7.846824e+04 78468.24 5.098200e+02 2023 958822 1.452981e+11 99.2045816 12.00 HURRICANE IDALIA Hurricane 4
4685 13035 2023-01-16 1 1 1 2.599814e+06 2599813.53 2.117000e+02 2023 25426 3.890726e+09 16.6083360 42.46 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4738 13075 2023-09-07 1 1 1 1.687436e+05 168743.57 8.300000e+01 2023 17209 3.573371e+09 60.0381801 33.83 HURRICANE IDALIA Hurricane 4
4738 13185 2023-09-07 1 1 1 4.758775e+06 4758774.53 6.000000e+01 2023 118124 2.074955e+10 81.3553929 42.20 HURRICANE IDALIA Hurricane 4
4685 13255 2023-01-16 4 4 4 6.697894e+06 6697893.83 5.685100e+03 2023 67247 1.203496e+10 44.8615972 40.20 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4685 13285 2023-01-16 1 1 1 1.250307e+04 12503.07 1.152000e+03 2023 69343 1.439801e+10 67.3242125 46.02 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4704 18007 2023-04-15 1 1 1 1.208304e+04 12083.04 8.646000e+03 2023 8719 2.087997e+09 11.1358575 62.35 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 5
4704 18023 2023-04-15 1 1 1 6.632260e+03 6632.26 2.193614e+01 2023 33183 5.454152e+09 40.0572701 71.07 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 5
4704 18081 2023-04-15 2 2 2 1.430079e+04 13300.79 6.262000e+02 2023 161668 3.055103e+10 81.7371938 88.86 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 5
4704 18109 2023-04-15 1 1 1 9.961140e+04 99611.40 6.060000e+03 2023 71729 1.362281e+10 62.5835189 78.80 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 5
4702 21073 2023-04-10 1 1 1 1.150672e+05 115067.20 8.000000e+01 2023 51521 1.006136e+10 62.8062361 71.55 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 4
4702 21155 2023-04-10 1 1 1 6.451137e+04 64511.37 2.724600e+02 2023 19521 4.044451e+09 33.3439389 61.90 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 4
4702 21203 2023-04-10 1 1 1 8.287000e+03 0.00 6.000000e+01 2023 16028 2.658793e+09 17.6901050 20.66 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 4
4702 21227 2023-04-10 1 1 1 2.064716e+05 206471.58 1.124000e+02 2023 134482 2.463868e+10 83.0098632 64.99 SEVERE STORMS, STRAIGHT-LINE WINDS, TORNADOES, FLOODING, LANDSLIDES, AND MUDSLIDES Severe Storm 4
4696 23013 2023-03-22 1 1 1 8.691740e+03 8691.74 1.400000e+01 2023 40597 9.304553e+09 50.4931594 97.61 SEVERE STORM AND FLOODING Severe Storm 1
4696 23031 2023-03-22 1 1 1 2.426894e+04 24268.94 2.000000e+01 2023 211925 4.450945e+10 83.6143812 85.84 SEVERE STORM AND FLOODING Severe Storm 1
4697 28015 2023-03-26 1 1 1 5.004668e+05 500466.78 3.118400e+03 2023 9971 1.639614e+09 16.0674515 26.26 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4727 28059 2023-08-12 1 1 1 7.718024e+05 771802.42 1.481796e+04 2023 143149 2.306976e+10 95.9910913 75.88 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES. Severe Storm 4
4697 28095 2023-03-26 12 6 6 2.967720e+07 19139114.29 1.972424e+05 2023 34055 5.885635e+09 63.0607700 43.76 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4697 28097 2023-03-26 1 1 1 3.707440e+04 37074.40 7.224000e+01 2023 9775 1.587660e+09 22.2717149 27.59 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4697 28125 2023-03-26 4 4 4 1.078583e+07 10785827.85 4.687428e+05 2023 3773 7.697461e+08 29.0486796 25.46 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4697 28149 2023-03-26 1 1 1 1.000000e+04 10000.00 2.000000e+01 2023 44654 9.795010e+09 76.5192491 68.11 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4725 34041 2023-08-11 1 1 1 4.173197e+05 417319.66 6.346000e+03 2023 109580 2.614011e+10 75.3102132 84.12 SEVERE STORM AND FLOODING Severe Storm 2
4706 40125 2023-04-24 1 1 1 4.336627e+06 4336627.23 2.172210e+04 2023 72357 8.784389e+09 85.9051861 51.85 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Tornado 6
4701 47015 2023-04-07 1 1 1 1.541853e+05 154185.33 1.250000e+04 2023 14490 2.125417e+09 18.8355075 26.67 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4701 47071 2023-04-07 1 1 1 2.393908e+05 239390.75 9.500000e+02 2023 26745 4.834413e+09 52.4021635 34.09 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4701 47149 2023-04-07 1 1 1 1.144501e+05 114450.07 6.318400e+02 2023 341253 6.433455e+10 88.2278078 70.53 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4751 47165 2023-12-13 1 1 1 2.074564e+05 207456.41 1.800474e+00 2023 196179 3.417330e+10 83.3598473 57.54 SEVERE STORMS AND TORNADOES Severe Storm 4
4701 47167 2023-04-07 5 2 2 6.118566e+06 3362144.66 6.664860e+04 2023 60942 8.944088e+09 80.3372574 56.27 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4701 47181 2023-04-07 2 2 2 5.857980e+05 585797.97 1.340000e+03 2023 16204 2.124535e+09 44.6706968 11.39 SEVERE STORMS, STRAIGHT-LINE WINDS, AND TORNADOES Severe Storm 4
4720 50023 2023-07-14 6 6 6 1.871425e+06 1871424.72 8.999176e+04 2023 59777 1.290725e+10 56.7610563 90.87 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 1
4720 50025 2023-07-14 3 3 3 2.713912e+04 27139.12 1.853500e+02 2023 45853 1.231266e+10 48.6159720 69.76 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 1
4720 50027 2023-07-14 1 1 1 1.363750e+04 13637.50 6.684800e+02 2023 57706 1.478996e+10 56.9201400 67.00 SEVERE STORMS, FLOODING, LANDSLIDES, AND MUDSLIDES Flood 1

1.3.2 The Data Summary

## [1] 319.7977
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##    0.00   28.98  117.58     Inf  495.34     Inf

Minimum, Central Tendency and Quartile Points. The first quartile value 29 dollars, is close to the currently used value of 35 dollars per yard of Construction Debris removal.

Median Cost is at 117 dollars. The Mean value is not calculated here, because projects with 0 values (for quantity) create an error. The trimmed mean (which removes the outlier/errors) is $319.

The Mean is skewed by extremely high cost projects. This is why we log (exponentially) scale quantity and cost in most of the analysis.

1.3.3 Viewing that summary:

Again, we see that Region 4 looks similar to others, so we can attempt to use all the data in grants manager to fit a more robust relationship.

1.3.4 The Cost & Quantity Relationship

  • Here Region 4 is shown as a separate color, however, it is very similar to the spread of other projects.
  • Note: We have removed extreme outliers from this chart already.
  • This chart is interactive if you are viewing in your browser.

1.3.5 Formulas Explained

  • Just like for Vegetative Debris, I’ve fit a line through this data cloud, and the converted that to a formula that can be used to estimate costs.
  • Slope intercept formula converted to log-log format is:
  • \(log10(y) = intercept + slope * log10(x)\)
  • Example for 10000 Cubic Yards
  • \(log10(10000) ~= 2.175 + .925 * log10(100)\)
  • \(4 ~= 2.175 + .925 * 2\)

(Actual answer for 100 cubic yards = 4.025, so 10^4.025 = $10592.54 Formula for CY \(10^ (log10(Cubic Yards) *.925 + 2.175)\)

Note: I fit this relationship… with an eye test. An actual regression relationship fit to this is… below. The numbers come out slightly different, but it’s a reasonable approximation.

1.3.6 Regression Fitting

cd_model <- cd_pred_MT %>% 
filter(Quantity > 10, 
       Gross_Cost < 1.25e08,
       is.na(Quantity)==FALSE,
       is.na(Gross_Cost)==FALSE) %>% 
    lm(formula = log10(1+Gross_Cost) ~ log10(1+Quantity))

summary(cd_model)
## 
## Call:
## lm(formula = log10(1 + Gross_Cost) ~ log10(1 + Quantity), data = .)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -4.6563 -0.5803  0.0339  0.6386  2.6086 
## 
## Coefficients:
##                     Estimate Std. Error t value Pr(>|t|)    
## (Intercept)          3.56817    0.11169   31.95   <2e-16 ***
## log10(1 + Quantity)  0.54892    0.02945   18.64   <2e-16 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 0.8992 on 592 degrees of freedom
## Multiple R-squared:  0.3698, Adjusted R-squared:  0.3688 
## F-statistic: 347.4 on 1 and 592 DF,  p-value: < 2.2e-16

Notes: - The model is *okay. SIgnificant fit, moderate R^2. - There is a lot of variance in trying to fit a single straight line through the widely disperesed cloud, so on either end, we have large residiuals (the difference between the line and data points). - A formula derived from this could be good in the aggregate but could be off by a lot for individual predictions.

1.3.7 Creating Functions to Show the Estimates

cy_eye_formula <- function(CY){
  10^ (log10(CY) *.925 + 2.175)
}

cy_reg_formula <- function(CY){
  10^(log10(CY)*0.54892  + 3.56817)
}

cy_reg_formula(100)
## [1] 46345.76
#46345.76
cy_eye_formula(100)
## [1] 10592.54
#10592.54

1.3.8 The differences in how these two relationships predict:

  • If we want to choose one that undershoots costs - we can go with Blue line.
  • This is what our Region 4 POCs preferred, as they would rather underestimate costs since this is being used in pre-declaration assessment to determine if a given county will get declared or not.

1.3.9 Formula Predictions v Actuals

1.3.9.1 Notes:

  • The blue line is the ‘Regression Predictions’ (reg_preds)‘, red line is the ’Eye Prediction’ (eye_pred)
  • The chart is interactive.
  • They are slightly differently balanced, in my opinion, the eye prediction formula should be preferred under 500-8000 Cubic Yards of quantity, then the regression predictor satisfies Region 4’s approach better at higher numbers of Cubic Yardage to be removed.
  • The formula promoted in the BLUF section uses the regression formula.

1.4 Appendix



1.4.1 Assessing Historials as Predictors in Complex Model

# load(file="historicals.rda")
# #glimpse(hist)
# names(hist) <- gsub(names(hist), pattern = " ", replacement = "_")
# hist[,3:51] <- lapply(hist[,3:51],FUN = as.numeric)
# 
# veg_pred.m.hist <- left_join(veg_pred.m, hist, by="FIPS")
# veg_pred.m.hist$year <- factor(veg_pred.m.hist$year, ordered=T)
# veg_pred.m.hist$USPS <- factor(veg_pred.m.hist$USPS, ordered=F)
# 
# cor.test(veg_pred.m.hist$Gross_Cost, veg_pred.m.hist$`Historical_Vegetative_75th_Quantile_Gross_Cost.75%`)
# #0.24, fairly weak...
# 
# #library(lme4)
# veg_multi_mod <- 
#   veg_pred.m.hist %>% filter(
#     Quantity > 10,
#     Gross_Cost > 500,
#     Gross_Cost < 1e07) %>% 
#   lme4::lmer(formula = log10(Gross_Cost) ~ log10(Quantity) +
#              `Historical_Vegetative_75th_Quantile_Gross_Cost.75%` 
#              + year
#              + (1|USPS))
# 
# summary(veg_multi_mod)
# 
# 
# #veg_lm_mod_state <- 
# #  veg_pred.m.hist %>% filter(
# #    Quantity > 10,
# #    Gross_Cost > 500,
# #    Gross_Cost < 1e07) %>% 
# #  lm(formula = log10(Gross_Cost) ~ log10(Quantity) + USPS)
# 
# #summary(veg_lm_mod_state)  # state not a useful variable. 

Successful modeling, but not really adding much of significance. Would need to evalauate a larger field of predictors, particularly those that don’t come from GM (cross contamination data, since the 75th for costs are some composite from the predictand anyway…)

# piecewiseSEM::rsquared(veg_multi_mod) 
# piecewiseSEM::rsquared(veg_model)

#LOWER RSQUARED than the simple model, no reason to do a complex process for what we may think (but can’t really prove) are different, nested structures influencing this process. States/Counties are more alike than different… is the simple conclusion.

The idea here would be to have separate intercepts for each state (or if we could get down to it… each county) as R4 would like multipliers or factors for states and counties where the number is higher… lower etc…

At least in this model, the differences aren’t too meaningful.



1.4.2 Additional Data Views and Visualization.

1.4.2.1 Project Based Aggregation and Exploration

# load("input_tables/Vegetative_Debris_CY_Debris_Data_By_Applicant_Project_Id.rda", verbose=T)
# glimpse(CY_Debris_Data_By_Applicant_Project_Id)
# 
# veg_stat <- CY_Debris_Data_By_Applicant_Project_Id %>% 
#   group_by(State, County, Applicant_Project_Id) %>% summarise(
#     .groups = "keep",
#     Gross_Cost = max(Gross_Cost, na.rm=T),
#     Quantity = sum(Quantity, na.rm=T)
#   ) %>% 
#   ungroup()
# glimpse(veg_stat)

CTA: Previous work made this look like an exponential or power law relationship, attempting to fix exponential/poly models and see how close they fit the line, could use that as a product for the R4 group. (There is still a large error term..)

Look at fitting various exponential relationships